﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Order" targetNamespace="http://tempuri.org/Order.xsd" xmlns:mstns="http://tempuri.org/Order.xsd" xmlns="http://tempuri.org/Order.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="nop190DevConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Public" Name="nop190DevConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.brevis.Nop.Report.Data.Properties.Settings.GlobalReference.Default.nop190DevConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Nop_Report_OrderTableAdapter" GeneratorDataComponentClassName="Nop_Report_OrderTableAdapter" Name="Nop_Report_Order" UserDataComponentName="Nop_Report_OrderTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="nop190DevConnectionString (Settings)" DbObjectName="nop190Dev.dbo.Nop_Report_Order" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT OrderID, OrderGUID, CustomerID, CustomerLanguageID, CustomerTaxDisplayTypeID, CustomerIP, OrderSubtotalInclTax, OrderSubtotalExclTax, OrderSubTotalDiscountInclTax, OrderSubTotalDiscountExclTax, OrderShippingInclTax, OrderShippingExclTax, PaymentMethodAdditionalFeeInclTax, PaymentMethodAdditionalFeeExclTax, TaxRates, OrderTax, OrderTotal, RefundedAmount, OrderDiscount, OrderSubtotalInclTaxInCustomerCurrency, OrderSubtotalExclTaxInCustomerCurrency, OrderSubTotalDiscountInclTaxInCustomerCurrency, OrderSubTotalDiscountExclTaxInCustomerCurrency, OrderShippingInclTaxInCustomerCurrency, OrderShippingExclTaxInCustomerCurrency, PaymentMethodAdditionalFeeInclTaxInCustomerCurrency, PaymentMethodAdditionalFeeExclTaxInCustomerCurrency, TaxRatesInCustomerCurrency, OrderTaxInCustomerCurrency, OrderTotalInCustomerCurrency, OrderDiscountInCustomerCurrency, CustomerCurrencyCode, CheckoutAttributeDescription, CheckoutAttributesXML, OrderWeight, AffiliateID, OrderStatusID, AllowStoringCreditCardNumber, CardType, CardName, CardNumber, MaskedCreditCardNumber, CardCVV2, CardExpirationMonth, CardExpirationYear, PaymentMethodID, PaymentMethodName, AuthorizationTransactionID, AuthorizationTransactionCode, AuthorizationTransactionResult, CaptureTransactionID, CaptureTransactionResult, SubscriptionTransactionID, PurchaseOrderNumber, PaymentStatusID, PaidDate, BillingFirstName, BillingLastName, BillingPhoneNumber, BillingEmail, BillingFaxNumber, BillingCompany, BillingAddress1, BillingAddress2, BillingCity, BillingStateProvince, BillingStateProvinceID, BillingZipPostalCode, BillingCountry, BillingCountryID, ShippingStatusID, ShippingFirstName, ShippingLastName, ShippingPhoneNumber, ShippingEmail, ShippingFaxNumber, ShippingCompany, ShippingAddress1, ShippingAddress2, ShippingCity, ShippingStateProvince, ShippingStateProvinceID, ShippingZipPostalCode, ShippingCountry, ShippingCountryID, ShippingMethod, ShippingRateComputationMethodID, ShippedDate, TrackingNumber, DeliveryDate, VatNumber, Deleted, CreatedOn, OrderProductVariantID, ProductVariantID, UnitPriceInclTax, UnitPriceExclTax, PriceInclTax, PriceExclTax, UnitPriceInclTaxInCustomerCurrency, UnitPriceExclTaxInCustomerCurrency, PriceInclTaxInCustomerCurrency, PriceExclTaxInCustomerCurrency, AttributeDescription, AttributesXML, Quantity, DiscountAmountInclTax, DiscountAmountExclTax, DownloadCount, OrderProductVariantGUID, IsDownloadActivated, LicenseDownloadID, ProductID, Name, SKU, Description, AdminComment, ManufacturerPartNumber, IsGiftCard, GiftCardType, IsDownload, DownloadID, UnlimitedDownloads, MaxNumberOfDownloads, DownloadExpirationDays, DownloadActivationType, HasSampleDownload, SampleDownloadID, HasUserAgreement, UserAgreementText, IsRecurring, CycleLength, CyclePeriod, TotalCycles, IsShipEnabled, IsFreeShipping, AdditionalShippingCharge, IsTaxExempt, TaxCategoryID, ManageInventory, StockQuantity, DisplayStockAvailability, DisplayStockQuantity, MinStockQuantity, LowStockActivityID, NotifyAdminForQuantityBelow, Backorders, OrderMinimumQuantity, OrderMaximumQuantity, WarehouseID, DisableBuyButton, CallForPrice, Price, OldPrice, ProductCost, CustomerEntersPrice, MinimumCustomerEnteredPrice, MaximumCustomerEnteredPrice, Weight, Length, Width, Height, PictureID, AvailableStartDateTime, AvailableEndDateTime, Published, DisplayOrder, UpdatedOn, ProductName, ShortDescription, FullDescription, TemplateID, ShowOnHomePage, MetaKeywords, MetaDescription, MetaTitle, SEName, AllowCustomerReviews, AllowCustomerRatings, RatingSum, TotalRatingVotes FROM dbo.Nop_Report_Order</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="OrderID" DataSetColumn="OrderID" />
              <Mapping SourceColumn="OrderGUID" DataSetColumn="OrderGUID" />
              <Mapping SourceColumn="CustomerID" DataSetColumn="CustomerID" />
              <Mapping SourceColumn="CustomerLanguageID" DataSetColumn="CustomerLanguageID" />
              <Mapping SourceColumn="CustomerTaxDisplayTypeID" DataSetColumn="CustomerTaxDisplayTypeID" />
              <Mapping SourceColumn="CustomerIP" DataSetColumn="CustomerIP" />
              <Mapping SourceColumn="OrderSubtotalInclTax" DataSetColumn="OrderSubtotalInclTax" />
              <Mapping SourceColumn="OrderSubtotalExclTax" DataSetColumn="OrderSubtotalExclTax" />
              <Mapping SourceColumn="OrderSubTotalDiscountInclTax" DataSetColumn="OrderSubTotalDiscountInclTax" />
              <Mapping SourceColumn="OrderSubTotalDiscountExclTax" DataSetColumn="OrderSubTotalDiscountExclTax" />
              <Mapping SourceColumn="OrderShippingInclTax" DataSetColumn="OrderShippingInclTax" />
              <Mapping SourceColumn="OrderShippingExclTax" DataSetColumn="OrderShippingExclTax" />
              <Mapping SourceColumn="PaymentMethodAdditionalFeeInclTax" DataSetColumn="PaymentMethodAdditionalFeeInclTax" />
              <Mapping SourceColumn="PaymentMethodAdditionalFeeExclTax" DataSetColumn="PaymentMethodAdditionalFeeExclTax" />
              <Mapping SourceColumn="TaxRates" DataSetColumn="TaxRates" />
              <Mapping SourceColumn="OrderTax" DataSetColumn="OrderTax" />
              <Mapping SourceColumn="OrderTotal" DataSetColumn="OrderTotal" />
              <Mapping SourceColumn="RefundedAmount" DataSetColumn="RefundedAmount" />
              <Mapping SourceColumn="OrderDiscount" DataSetColumn="OrderDiscount" />
              <Mapping SourceColumn="OrderSubtotalInclTaxInCustomerCurrency" DataSetColumn="OrderSubtotalInclTaxInCustomerCurrency" />
              <Mapping SourceColumn="OrderSubtotalExclTaxInCustomerCurrency" DataSetColumn="OrderSubtotalExclTaxInCustomerCurrency" />
              <Mapping SourceColumn="OrderSubTotalDiscountInclTaxInCustomerCurrency" DataSetColumn="OrderSubTotalDiscountInclTaxInCustomerCurrency" />
              <Mapping SourceColumn="OrderSubTotalDiscountExclTaxInCustomerCurrency" DataSetColumn="OrderSubTotalDiscountExclTaxInCustomerCurrency" />
              <Mapping SourceColumn="OrderShippingInclTaxInCustomerCurrency" DataSetColumn="OrderShippingInclTaxInCustomerCurrency" />
              <Mapping SourceColumn="OrderShippingExclTaxInCustomerCurrency" DataSetColumn="OrderShippingExclTaxInCustomerCurrency" />
              <Mapping SourceColumn="PaymentMethodAdditionalFeeInclTaxInCustomerCurrency" DataSetColumn="PaymentMethodAdditionalFeeInclTaxInCustomerCurrency" />
              <Mapping SourceColumn="PaymentMethodAdditionalFeeExclTaxInCustomerCurrency" DataSetColumn="PaymentMethodAdditionalFeeExclTaxInCustomerCurrency" />
              <Mapping SourceColumn="TaxRatesInCustomerCurrency" DataSetColumn="TaxRatesInCustomerCurrency" />
              <Mapping SourceColumn="OrderTaxInCustomerCurrency" DataSetColumn="OrderTaxInCustomerCurrency" />
              <Mapping SourceColumn="OrderTotalInCustomerCurrency" DataSetColumn="OrderTotalInCustomerCurrency" />
              <Mapping SourceColumn="OrderDiscountInCustomerCurrency" DataSetColumn="OrderDiscountInCustomerCurrency" />
              <Mapping SourceColumn="CustomerCurrencyCode" DataSetColumn="CustomerCurrencyCode" />
              <Mapping SourceColumn="CheckoutAttributeDescription" DataSetColumn="CheckoutAttributeDescription" />
              <Mapping SourceColumn="CheckoutAttributesXML" DataSetColumn="CheckoutAttributesXML" />
              <Mapping SourceColumn="OrderWeight" DataSetColumn="OrderWeight" />
              <Mapping SourceColumn="AffiliateID" DataSetColumn="AffiliateID" />
              <Mapping SourceColumn="OrderStatusID" DataSetColumn="OrderStatusID" />
              <Mapping SourceColumn="AllowStoringCreditCardNumber" DataSetColumn="AllowStoringCreditCardNumber" />
              <Mapping SourceColumn="CardType" DataSetColumn="CardType" />
              <Mapping SourceColumn="CardName" DataSetColumn="CardName" />
              <Mapping SourceColumn="CardNumber" DataSetColumn="CardNumber" />
              <Mapping SourceColumn="MaskedCreditCardNumber" DataSetColumn="MaskedCreditCardNumber" />
              <Mapping SourceColumn="CardCVV2" DataSetColumn="CardCVV2" />
              <Mapping SourceColumn="CardExpirationMonth" DataSetColumn="CardExpirationMonth" />
              <Mapping SourceColumn="CardExpirationYear" DataSetColumn="CardExpirationYear" />
              <Mapping SourceColumn="PaymentMethodID" DataSetColumn="PaymentMethodID" />
              <Mapping SourceColumn="PaymentMethodName" DataSetColumn="PaymentMethodName" />
              <Mapping SourceColumn="AuthorizationTransactionID" DataSetColumn="AuthorizationTransactionID" />
              <Mapping SourceColumn="AuthorizationTransactionCode" DataSetColumn="AuthorizationTransactionCode" />
              <Mapping SourceColumn="AuthorizationTransactionResult" DataSetColumn="AuthorizationTransactionResult" />
              <Mapping SourceColumn="CaptureTransactionID" DataSetColumn="CaptureTransactionID" />
              <Mapping SourceColumn="CaptureTransactionResult" DataSetColumn="CaptureTransactionResult" />
              <Mapping SourceColumn="SubscriptionTransactionID" DataSetColumn="SubscriptionTransactionID" />
              <Mapping SourceColumn="PurchaseOrderNumber" DataSetColumn="PurchaseOrderNumber" />
              <Mapping SourceColumn="PaymentStatusID" DataSetColumn="PaymentStatusID" />
              <Mapping SourceColumn="PaidDate" DataSetColumn="PaidDate" />
              <Mapping SourceColumn="BillingFirstName" DataSetColumn="BillingFirstName" />
              <Mapping SourceColumn="BillingLastName" DataSetColumn="BillingLastName" />
              <Mapping SourceColumn="BillingPhoneNumber" DataSetColumn="BillingPhoneNumber" />
              <Mapping SourceColumn="BillingEmail" DataSetColumn="BillingEmail" />
              <Mapping SourceColumn="BillingFaxNumber" DataSetColumn="BillingFaxNumber" />
              <Mapping SourceColumn="BillingCompany" DataSetColumn="BillingCompany" />
              <Mapping SourceColumn="BillingAddress1" DataSetColumn="BillingAddress1" />
              <Mapping SourceColumn="BillingAddress2" DataSetColumn="BillingAddress2" />
              <Mapping SourceColumn="BillingCity" DataSetColumn="BillingCity" />
              <Mapping SourceColumn="BillingStateProvince" DataSetColumn="BillingStateProvince" />
              <Mapping SourceColumn="BillingStateProvinceID" DataSetColumn="BillingStateProvinceID" />
              <Mapping SourceColumn="BillingZipPostalCode" DataSetColumn="BillingZipPostalCode" />
              <Mapping SourceColumn="BillingCountry" DataSetColumn="BillingCountry" />
              <Mapping SourceColumn="BillingCountryID" DataSetColumn="BillingCountryID" />
              <Mapping SourceColumn="ShippingStatusID" DataSetColumn="ShippingStatusID" />
              <Mapping SourceColumn="ShippingFirstName" DataSetColumn="ShippingFirstName" />
              <Mapping SourceColumn="ShippingLastName" DataSetColumn="ShippingLastName" />
              <Mapping SourceColumn="ShippingPhoneNumber" DataSetColumn="ShippingPhoneNumber" />
              <Mapping SourceColumn="ShippingEmail" DataSetColumn="ShippingEmail" />
              <Mapping SourceColumn="ShippingFaxNumber" DataSetColumn="ShippingFaxNumber" />
              <Mapping SourceColumn="ShippingCompany" DataSetColumn="ShippingCompany" />
              <Mapping SourceColumn="ShippingAddress1" DataSetColumn="ShippingAddress1" />
              <Mapping SourceColumn="ShippingAddress2" DataSetColumn="ShippingAddress2" />
              <Mapping SourceColumn="ShippingCity" DataSetColumn="ShippingCity" />
              <Mapping SourceColumn="ShippingStateProvince" DataSetColumn="ShippingStateProvince" />
              <Mapping SourceColumn="ShippingStateProvinceID" DataSetColumn="ShippingStateProvinceID" />
              <Mapping SourceColumn="ShippingZipPostalCode" DataSetColumn="ShippingZipPostalCode" />
              <Mapping SourceColumn="ShippingCountry" DataSetColumn="ShippingCountry" />
              <Mapping SourceColumn="ShippingCountryID" DataSetColumn="ShippingCountryID" />
              <Mapping SourceColumn="ShippingMethod" DataSetColumn="ShippingMethod" />
              <Mapping SourceColumn="ShippingRateComputationMethodID" DataSetColumn="ShippingRateComputationMethodID" />
              <Mapping SourceColumn="ShippedDate" DataSetColumn="ShippedDate" />
              <Mapping SourceColumn="TrackingNumber" DataSetColumn="TrackingNumber" />
              <Mapping SourceColumn="DeliveryDate" DataSetColumn="DeliveryDate" />
              <Mapping SourceColumn="VatNumber" DataSetColumn="VatNumber" />
              <Mapping SourceColumn="Deleted" DataSetColumn="Deleted" />
              <Mapping SourceColumn="CreatedOn" DataSetColumn="CreatedOn" />
              <Mapping SourceColumn="OrderProductVariantID" DataSetColumn="OrderProductVariantID" />
              <Mapping SourceColumn="ProductVariantID" DataSetColumn="ProductVariantID" />
              <Mapping SourceColumn="UnitPriceInclTax" DataSetColumn="UnitPriceInclTax" />
              <Mapping SourceColumn="UnitPriceExclTax" DataSetColumn="UnitPriceExclTax" />
              <Mapping SourceColumn="PriceInclTax" DataSetColumn="PriceInclTax" />
              <Mapping SourceColumn="PriceExclTax" DataSetColumn="PriceExclTax" />
              <Mapping SourceColumn="UnitPriceInclTaxInCustomerCurrency" DataSetColumn="UnitPriceInclTaxInCustomerCurrency" />
              <Mapping SourceColumn="UnitPriceExclTaxInCustomerCurrency" DataSetColumn="UnitPriceExclTaxInCustomerCurrency" />
              <Mapping SourceColumn="PriceInclTaxInCustomerCurrency" DataSetColumn="PriceInclTaxInCustomerCurrency" />
              <Mapping SourceColumn="PriceExclTaxInCustomerCurrency" DataSetColumn="PriceExclTaxInCustomerCurrency" />
              <Mapping SourceColumn="AttributeDescription" DataSetColumn="AttributeDescription" />
              <Mapping SourceColumn="AttributesXML" DataSetColumn="AttributesXML" />
              <Mapping SourceColumn="Quantity" DataSetColumn="Quantity" />
              <Mapping SourceColumn="DiscountAmountInclTax" DataSetColumn="DiscountAmountInclTax" />
              <Mapping SourceColumn="DiscountAmountExclTax" DataSetColumn="DiscountAmountExclTax" />
              <Mapping SourceColumn="DownloadCount" DataSetColumn="DownloadCount" />
              <Mapping SourceColumn="OrderProductVariantGUID" DataSetColumn="OrderProductVariantGUID" />
              <Mapping SourceColumn="IsDownloadActivated" DataSetColumn="IsDownloadActivated" />
              <Mapping SourceColumn="LicenseDownloadID" DataSetColumn="LicenseDownloadID" />
              <Mapping SourceColumn="ProductID" DataSetColumn="ProductID" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="SKU" DataSetColumn="SKU" />
              <Mapping SourceColumn="Description" DataSetColumn="Description" />
              <Mapping SourceColumn="AdminComment" DataSetColumn="AdminComment" />
              <Mapping SourceColumn="ManufacturerPartNumber" DataSetColumn="ManufacturerPartNumber" />
              <Mapping SourceColumn="IsGiftCard" DataSetColumn="IsGiftCard" />
              <Mapping SourceColumn="GiftCardType" DataSetColumn="GiftCardType" />
              <Mapping SourceColumn="IsDownload" DataSetColumn="IsDownload" />
              <Mapping SourceColumn="DownloadID" DataSetColumn="DownloadID" />
              <Mapping SourceColumn="UnlimitedDownloads" DataSetColumn="UnlimitedDownloads" />
              <Mapping SourceColumn="MaxNumberOfDownloads" DataSetColumn="MaxNumberOfDownloads" />
              <Mapping SourceColumn="DownloadExpirationDays" DataSetColumn="DownloadExpirationDays" />
              <Mapping SourceColumn="DownloadActivationType" DataSetColumn="DownloadActivationType" />
              <Mapping SourceColumn="HasSampleDownload" DataSetColumn="HasSampleDownload" />
              <Mapping SourceColumn="SampleDownloadID" DataSetColumn="SampleDownloadID" />
              <Mapping SourceColumn="HasUserAgreement" DataSetColumn="HasUserAgreement" />
              <Mapping SourceColumn="UserAgreementText" DataSetColumn="UserAgreementText" />
              <Mapping SourceColumn="IsRecurring" DataSetColumn="IsRecurring" />
              <Mapping SourceColumn="CycleLength" DataSetColumn="CycleLength" />
              <Mapping SourceColumn="CyclePeriod" DataSetColumn="CyclePeriod" />
              <Mapping SourceColumn="TotalCycles" DataSetColumn="TotalCycles" />
              <Mapping SourceColumn="IsShipEnabled" DataSetColumn="IsShipEnabled" />
              <Mapping SourceColumn="IsFreeShipping" DataSetColumn="IsFreeShipping" />
              <Mapping SourceColumn="AdditionalShippingCharge" DataSetColumn="AdditionalShippingCharge" />
              <Mapping SourceColumn="IsTaxExempt" DataSetColumn="IsTaxExempt" />
              <Mapping SourceColumn="TaxCategoryID" DataSetColumn="TaxCategoryID" />
              <Mapping SourceColumn="ManageInventory" DataSetColumn="ManageInventory" />
              <Mapping SourceColumn="StockQuantity" DataSetColumn="StockQuantity" />
              <Mapping SourceColumn="DisplayStockAvailability" DataSetColumn="DisplayStockAvailability" />
              <Mapping SourceColumn="DisplayStockQuantity" DataSetColumn="DisplayStockQuantity" />
              <Mapping SourceColumn="MinStockQuantity" DataSetColumn="MinStockQuantity" />
              <Mapping SourceColumn="LowStockActivityID" DataSetColumn="LowStockActivityID" />
              <Mapping SourceColumn="NotifyAdminForQuantityBelow" DataSetColumn="NotifyAdminForQuantityBelow" />
              <Mapping SourceColumn="Backorders" DataSetColumn="Backorders" />
              <Mapping SourceColumn="OrderMinimumQuantity" DataSetColumn="OrderMinimumQuantity" />
              <Mapping SourceColumn="OrderMaximumQuantity" DataSetColumn="OrderMaximumQuantity" />
              <Mapping SourceColumn="WarehouseID" DataSetColumn="WarehouseID" />
              <Mapping SourceColumn="DisableBuyButton" DataSetColumn="DisableBuyButton" />
              <Mapping SourceColumn="CallForPrice" DataSetColumn="CallForPrice" />
              <Mapping SourceColumn="Price" DataSetColumn="Price" />
              <Mapping SourceColumn="OldPrice" DataSetColumn="OldPrice" />
              <Mapping SourceColumn="ProductCost" DataSetColumn="ProductCost" />
              <Mapping SourceColumn="CustomerEntersPrice" DataSetColumn="CustomerEntersPrice" />
              <Mapping SourceColumn="MinimumCustomerEnteredPrice" DataSetColumn="MinimumCustomerEnteredPrice" />
              <Mapping SourceColumn="MaximumCustomerEnteredPrice" DataSetColumn="MaximumCustomerEnteredPrice" />
              <Mapping SourceColumn="Weight" DataSetColumn="Weight" />
              <Mapping SourceColumn="Length" DataSetColumn="Length" />
              <Mapping SourceColumn="Width" DataSetColumn="Width" />
              <Mapping SourceColumn="Height" DataSetColumn="Height" />
              <Mapping SourceColumn="PictureID" DataSetColumn="PictureID" />
              <Mapping SourceColumn="AvailableStartDateTime" DataSetColumn="AvailableStartDateTime" />
              <Mapping SourceColumn="AvailableEndDateTime" DataSetColumn="AvailableEndDateTime" />
              <Mapping SourceColumn="Published" DataSetColumn="Published" />
              <Mapping SourceColumn="DisplayOrder" DataSetColumn="DisplayOrder" />
              <Mapping SourceColumn="UpdatedOn" DataSetColumn="UpdatedOn" />
              <Mapping SourceColumn="ProductName" DataSetColumn="ProductName" />
              <Mapping SourceColumn="ShortDescription" DataSetColumn="ShortDescription" />
              <Mapping SourceColumn="FullDescription" DataSetColumn="FullDescription" />
              <Mapping SourceColumn="TemplateID" DataSetColumn="TemplateID" />
              <Mapping SourceColumn="ShowOnHomePage" DataSetColumn="ShowOnHomePage" />
              <Mapping SourceColumn="MetaKeywords" DataSetColumn="MetaKeywords" />
              <Mapping SourceColumn="MetaDescription" DataSetColumn="MetaDescription" />
              <Mapping SourceColumn="MetaTitle" DataSetColumn="MetaTitle" />
              <Mapping SourceColumn="SEName" DataSetColumn="SEName" />
              <Mapping SourceColumn="AllowCustomerReviews" DataSetColumn="AllowCustomerReviews" />
              <Mapping SourceColumn="AllowCustomerRatings" DataSetColumn="AllowCustomerRatings" />
              <Mapping SourceColumn="RatingSum" DataSetColumn="RatingSum" />
              <Mapping SourceColumn="TotalRatingVotes" DataSetColumn="TotalRatingVotes" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="Nop_Report_CustomerAddressTableAdapter" GeneratorDataComponentClassName="Nop_Report_CustomerAddressTableAdapter" Name="Nop_Report_CustomerAddress" UserDataComponentName="Nop_Report_CustomerAddressTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="nop190DevConnectionString (Settings)" DbObjectName="nop190Dev.dbo.Nop_Report_CustomerAddress" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT CustomerID, CustomerGUID, Email, Username, PasswordHash, SaltKey, AffiliateID, BillingAddressID, ShippingAddressID, LastPaymentMethodID, LastAppliedCouponCode, GiftCardCouponCodes, CheckoutAttributes, LanguageID, CurrencyID, TaxDisplayTypeID, IsTaxExempt, IsAdmin, IsGuest, IsForumModerator, TotalForumPosts, Signature, AdminComment, Active, Deleted, RegistrationDate, TimeZoneID, AvatarID, DateOfBirth, AddressId, Expr1, IsBillingAddress, FirstName, LastName, PhoneNumber, Expr2, FaxNumber, Company, Address1, Address2, City, StateProvinceID, ZipPostalCode, CountryID, CreatedOn, UpdatedOn FROM dbo.Nop_Report_CustomerAddress</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CustomerID" DataSetColumn="CustomerID" />
              <Mapping SourceColumn="CustomerGUID" DataSetColumn="CustomerGUID" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="PasswordHash" DataSetColumn="PasswordHash" />
              <Mapping SourceColumn="SaltKey" DataSetColumn="SaltKey" />
              <Mapping SourceColumn="AffiliateID" DataSetColumn="AffiliateID" />
              <Mapping SourceColumn="BillingAddressID" DataSetColumn="BillingAddressID" />
              <Mapping SourceColumn="ShippingAddressID" DataSetColumn="ShippingAddressID" />
              <Mapping SourceColumn="LastPaymentMethodID" DataSetColumn="LastPaymentMethodID" />
              <Mapping SourceColumn="LastAppliedCouponCode" DataSetColumn="LastAppliedCouponCode" />
              <Mapping SourceColumn="GiftCardCouponCodes" DataSetColumn="GiftCardCouponCodes" />
              <Mapping SourceColumn="CheckoutAttributes" DataSetColumn="CheckoutAttributes" />
              <Mapping SourceColumn="LanguageID" DataSetColumn="LanguageID" />
              <Mapping SourceColumn="CurrencyID" DataSetColumn="CurrencyID" />
              <Mapping SourceColumn="TaxDisplayTypeID" DataSetColumn="TaxDisplayTypeID" />
              <Mapping SourceColumn="IsTaxExempt" DataSetColumn="IsTaxExempt" />
              <Mapping SourceColumn="IsAdmin" DataSetColumn="IsAdmin" />
              <Mapping SourceColumn="IsGuest" DataSetColumn="IsGuest" />
              <Mapping SourceColumn="IsForumModerator" DataSetColumn="IsForumModerator" />
              <Mapping SourceColumn="TotalForumPosts" DataSetColumn="TotalForumPosts" />
              <Mapping SourceColumn="Signature" DataSetColumn="Signature" />
              <Mapping SourceColumn="AdminComment" DataSetColumn="AdminComment" />
              <Mapping SourceColumn="Active" DataSetColumn="Active" />
              <Mapping SourceColumn="Deleted" DataSetColumn="Deleted" />
              <Mapping SourceColumn="RegistrationDate" DataSetColumn="RegistrationDate" />
              <Mapping SourceColumn="TimeZoneID" DataSetColumn="TimeZoneID" />
              <Mapping SourceColumn="AvatarID" DataSetColumn="AvatarID" />
              <Mapping SourceColumn="DateOfBirth" DataSetColumn="DateOfBirth" />
              <Mapping SourceColumn="AddressId" DataSetColumn="AddressId" />
              <Mapping SourceColumn="Expr1" DataSetColumn="Expr1" />
              <Mapping SourceColumn="IsBillingAddress" DataSetColumn="IsBillingAddress" />
              <Mapping SourceColumn="FirstName" DataSetColumn="FirstName" />
              <Mapping SourceColumn="LastName" DataSetColumn="LastName" />
              <Mapping SourceColumn="PhoneNumber" DataSetColumn="PhoneNumber" />
              <Mapping SourceColumn="Expr2" DataSetColumn="Expr2" />
              <Mapping SourceColumn="FaxNumber" DataSetColumn="FaxNumber" />
              <Mapping SourceColumn="Company" DataSetColumn="Company" />
              <Mapping SourceColumn="Address1" DataSetColumn="Address1" />
              <Mapping SourceColumn="Address2" DataSetColumn="Address2" />
              <Mapping SourceColumn="City" DataSetColumn="City" />
              <Mapping SourceColumn="StateProvinceID" DataSetColumn="StateProvinceID" />
              <Mapping SourceColumn="ZipPostalCode" DataSetColumn="ZipPostalCode" />
              <Mapping SourceColumn="CountryID" DataSetColumn="CountryID" />
              <Mapping SourceColumn="CreatedOn" DataSetColumn="CreatedOn" />
              <Mapping SourceColumn="UpdatedOn" DataSetColumn="UpdatedOn" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Order" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="Order" msprop:Generator_UserDSName="Order">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Nop_Report_Order" msprop:Generator_TableClassName="Nop_Report_OrderDataTable" msprop:Generator_TableVarName="tableNop_Report_Order" msprop:Generator_RowChangedName="Nop_Report_OrderRowChanged" msprop:Generator_TablePropName="Nop_Report_Order" msprop:Generator_RowDeletingName="Nop_Report_OrderRowDeleting" msprop:Generator_RowChangingName="Nop_Report_OrderRowChanging" msprop:Generator_RowEvHandlerName="Nop_Report_OrderRowChangeEventHandler" msprop:Generator_RowDeletedName="Nop_Report_OrderRowDeleted" msprop:Generator_RowClassName="Nop_Report_OrderRow" msprop:Generator_UserTableName="Nop_Report_Order" msprop:Generator_RowEvArgName="Nop_Report_OrderRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="OrderID" msprop:Generator_ColumnVarNameInTable="columnOrderID" msprop:Generator_ColumnPropNameInRow="OrderID" msprop:Generator_ColumnPropNameInTable="OrderIDColumn" msprop:Generator_UserColumnName="OrderID" type="xs:int" />
              <xs:element name="OrderGUID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOrderGUID" msprop:Generator_ColumnPropNameInRow="OrderGUID" msprop:Generator_ColumnPropNameInTable="OrderGUIDColumn" msprop:Generator_UserColumnName="OrderGUID" type="xs:string" />
              <xs:element name="CustomerID" msprop:Generator_ColumnVarNameInTable="columnCustomerID" msprop:Generator_ColumnPropNameInRow="CustomerID" msprop:Generator_ColumnPropNameInTable="CustomerIDColumn" msprop:Generator_UserColumnName="CustomerID" type="xs:int" />
              <xs:element name="CustomerLanguageID" msprop:Generator_ColumnVarNameInTable="columnCustomerLanguageID" msprop:Generator_ColumnPropNameInRow="CustomerLanguageID" msprop:Generator_ColumnPropNameInTable="CustomerLanguageIDColumn" msprop:Generator_UserColumnName="CustomerLanguageID" type="xs:int" />
              <xs:element name="CustomerTaxDisplayTypeID" msprop:Generator_ColumnVarNameInTable="columnCustomerTaxDisplayTypeID" msprop:Generator_ColumnPropNameInRow="CustomerTaxDisplayTypeID" msprop:Generator_ColumnPropNameInTable="CustomerTaxDisplayTypeIDColumn" msprop:Generator_UserColumnName="CustomerTaxDisplayTypeID" type="xs:int" />
              <xs:element name="CustomerIP" msprop:Generator_ColumnVarNameInTable="columnCustomerIP" msprop:Generator_ColumnPropNameInRow="CustomerIP" msprop:Generator_ColumnPropNameInTable="CustomerIPColumn" msprop:Generator_UserColumnName="CustomerIP">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OrderSubtotalInclTax" msprop:Generator_ColumnVarNameInTable="columnOrderSubtotalInclTax" msprop:Generator_ColumnPropNameInRow="OrderSubtotalInclTax" msprop:Generator_ColumnPropNameInTable="OrderSubtotalInclTaxColumn" msprop:Generator_UserColumnName="OrderSubtotalInclTax" type="xs:decimal" />
              <xs:element name="OrderSubtotalExclTax" msprop:Generator_ColumnVarNameInTable="columnOrderSubtotalExclTax" msprop:Generator_ColumnPropNameInRow="OrderSubtotalExclTax" msprop:Generator_ColumnPropNameInTable="OrderSubtotalExclTaxColumn" msprop:Generator_UserColumnName="OrderSubtotalExclTax" type="xs:decimal" />
              <xs:element name="OrderSubTotalDiscountInclTax" msprop:Generator_ColumnVarNameInTable="columnOrderSubTotalDiscountInclTax" msprop:Generator_ColumnPropNameInRow="OrderSubTotalDiscountInclTax" msprop:Generator_ColumnPropNameInTable="OrderSubTotalDiscountInclTaxColumn" msprop:Generator_UserColumnName="OrderSubTotalDiscountInclTax" type="xs:decimal" />
              <xs:element name="OrderSubTotalDiscountExclTax" msprop:Generator_ColumnVarNameInTable="columnOrderSubTotalDiscountExclTax" msprop:Generator_ColumnPropNameInRow="OrderSubTotalDiscountExclTax" msprop:Generator_ColumnPropNameInTable="OrderSubTotalDiscountExclTaxColumn" msprop:Generator_UserColumnName="OrderSubTotalDiscountExclTax" type="xs:decimal" />
              <xs:element name="OrderShippingInclTax" msprop:Generator_ColumnVarNameInTable="columnOrderShippingInclTax" msprop:Generator_ColumnPropNameInRow="OrderShippingInclTax" msprop:Generator_ColumnPropNameInTable="OrderShippingInclTaxColumn" msprop:Generator_UserColumnName="OrderShippingInclTax" type="xs:decimal" />
              <xs:element name="OrderShippingExclTax" msprop:Generator_ColumnVarNameInTable="columnOrderShippingExclTax" msprop:Generator_ColumnPropNameInRow="OrderShippingExclTax" msprop:Generator_ColumnPropNameInTable="OrderShippingExclTaxColumn" msprop:Generator_UserColumnName="OrderShippingExclTax" type="xs:decimal" />
              <xs:element name="PaymentMethodAdditionalFeeInclTax" msprop:Generator_ColumnVarNameInTable="columnPaymentMethodAdditionalFeeInclTax" msprop:Generator_ColumnPropNameInRow="PaymentMethodAdditionalFeeInclTax" msprop:Generator_ColumnPropNameInTable="PaymentMethodAdditionalFeeInclTaxColumn" msprop:Generator_UserColumnName="PaymentMethodAdditionalFeeInclTax" type="xs:decimal" />
              <xs:element name="PaymentMethodAdditionalFeeExclTax" msprop:Generator_ColumnVarNameInTable="columnPaymentMethodAdditionalFeeExclTax" msprop:Generator_ColumnPropNameInRow="PaymentMethodAdditionalFeeExclTax" msprop:Generator_ColumnPropNameInTable="PaymentMethodAdditionalFeeExclTaxColumn" msprop:Generator_UserColumnName="PaymentMethodAdditionalFeeExclTax" type="xs:decimal" />
              <xs:element name="TaxRates" msprop:Generator_ColumnVarNameInTable="columnTaxRates" msprop:Generator_ColumnPropNameInRow="TaxRates" msprop:Generator_ColumnPropNameInTable="TaxRatesColumn" msprop:Generator_UserColumnName="TaxRates">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OrderTax" msprop:Generator_ColumnVarNameInTable="columnOrderTax" msprop:Generator_ColumnPropNameInRow="OrderTax" msprop:Generator_ColumnPropNameInTable="OrderTaxColumn" msprop:Generator_UserColumnName="OrderTax" type="xs:decimal" />
              <xs:element name="OrderTotal" msprop:Generator_ColumnVarNameInTable="columnOrderTotal" msprop:Generator_ColumnPropNameInRow="OrderTotal" msprop:Generator_ColumnPropNameInTable="OrderTotalColumn" msprop:Generator_UserColumnName="OrderTotal" type="xs:decimal" />
              <xs:element name="RefundedAmount" msprop:Generator_ColumnVarNameInTable="columnRefundedAmount" msprop:Generator_ColumnPropNameInRow="RefundedAmount" msprop:Generator_ColumnPropNameInTable="RefundedAmountColumn" msprop:Generator_UserColumnName="RefundedAmount" type="xs:decimal" />
              <xs:element name="OrderDiscount" msprop:Generator_ColumnVarNameInTable="columnOrderDiscount" msprop:Generator_ColumnPropNameInRow="OrderDiscount" msprop:Generator_ColumnPropNameInTable="OrderDiscountColumn" msprop:Generator_UserColumnName="OrderDiscount" type="xs:decimal" />
              <xs:element name="OrderSubtotalInclTaxInCustomerCurrency" msprop:Generator_ColumnVarNameInTable="columnOrderSubtotalInclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInRow="OrderSubtotalInclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInTable="OrderSubtotalInclTaxInCustomerCurrencyColumn" msprop:Generator_UserColumnName="OrderSubtotalInclTaxInCustomerCurrency" type="xs:decimal" />
              <xs:element name="OrderSubtotalExclTaxInCustomerCurrency" msprop:Generator_ColumnVarNameInTable="columnOrderSubtotalExclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInRow="OrderSubtotalExclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInTable="OrderSubtotalExclTaxInCustomerCurrencyColumn" msprop:Generator_UserColumnName="OrderSubtotalExclTaxInCustomerCurrency" type="xs:decimal" />
              <xs:element name="OrderSubTotalDiscountInclTaxInCustomerCurrency" msprop:Generator_ColumnVarNameInTable="columnOrderSubTotalDiscountInclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInRow="OrderSubTotalDiscountInclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInTable="OrderSubTotalDiscountInclTaxInCustomerCurrencyColumn" msprop:Generator_UserColumnName="OrderSubTotalDiscountInclTaxInCustomerCurrency" type="xs:decimal" />
              <xs:element name="OrderSubTotalDiscountExclTaxInCustomerCurrency" msprop:Generator_ColumnVarNameInTable="columnOrderSubTotalDiscountExclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInRow="OrderSubTotalDiscountExclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInTable="OrderSubTotalDiscountExclTaxInCustomerCurrencyColumn" msprop:Generator_UserColumnName="OrderSubTotalDiscountExclTaxInCustomerCurrency" type="xs:decimal" />
              <xs:element name="OrderShippingInclTaxInCustomerCurrency" msprop:Generator_ColumnVarNameInTable="columnOrderShippingInclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInRow="OrderShippingInclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInTable="OrderShippingInclTaxInCustomerCurrencyColumn" msprop:Generator_UserColumnName="OrderShippingInclTaxInCustomerCurrency" type="xs:decimal" />
              <xs:element name="OrderShippingExclTaxInCustomerCurrency" msprop:Generator_ColumnVarNameInTable="columnOrderShippingExclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInRow="OrderShippingExclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInTable="OrderShippingExclTaxInCustomerCurrencyColumn" msprop:Generator_UserColumnName="OrderShippingExclTaxInCustomerCurrency" type="xs:decimal" />
              <xs:element name="PaymentMethodAdditionalFeeInclTaxInCustomerCurrency" msprop:Generator_ColumnVarNameInTable="columnPaymentMethodAdditionalFeeInclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInRow="PaymentMethodAdditionalFeeInclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInTable="PaymentMethodAdditionalFeeInclTaxInCustomerCurrencyColumn" msprop:Generator_UserColumnName="PaymentMethodAdditionalFeeInclTaxInCustomerCurrency" type="xs:decimal" />
              <xs:element name="PaymentMethodAdditionalFeeExclTaxInCustomerCurrency" msprop:Generator_ColumnVarNameInTable="columnPaymentMethodAdditionalFeeExclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInRow="PaymentMethodAdditionalFeeExclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInTable="PaymentMethodAdditionalFeeExclTaxInCustomerCurrencyColumn" msprop:Generator_UserColumnName="PaymentMethodAdditionalFeeExclTaxInCustomerCurrency" type="xs:decimal" />
              <xs:element name="TaxRatesInCustomerCurrency" msprop:Generator_ColumnVarNameInTable="columnTaxRatesInCustomerCurrency" msprop:Generator_ColumnPropNameInRow="TaxRatesInCustomerCurrency" msprop:Generator_ColumnPropNameInTable="TaxRatesInCustomerCurrencyColumn" msprop:Generator_UserColumnName="TaxRatesInCustomerCurrency">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OrderTaxInCustomerCurrency" msprop:Generator_ColumnVarNameInTable="columnOrderTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInRow="OrderTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInTable="OrderTaxInCustomerCurrencyColumn" msprop:Generator_UserColumnName="OrderTaxInCustomerCurrency" type="xs:decimal" />
              <xs:element name="OrderTotalInCustomerCurrency" msprop:Generator_ColumnVarNameInTable="columnOrderTotalInCustomerCurrency" msprop:Generator_ColumnPropNameInRow="OrderTotalInCustomerCurrency" msprop:Generator_ColumnPropNameInTable="OrderTotalInCustomerCurrencyColumn" msprop:Generator_UserColumnName="OrderTotalInCustomerCurrency" type="xs:decimal" />
              <xs:element name="OrderDiscountInCustomerCurrency" msprop:Generator_ColumnVarNameInTable="columnOrderDiscountInCustomerCurrency" msprop:Generator_ColumnPropNameInRow="OrderDiscountInCustomerCurrency" msprop:Generator_ColumnPropNameInTable="OrderDiscountInCustomerCurrencyColumn" msprop:Generator_UserColumnName="OrderDiscountInCustomerCurrency" type="xs:decimal" />
              <xs:element name="CustomerCurrencyCode" msprop:Generator_ColumnVarNameInTable="columnCustomerCurrencyCode" msprop:Generator_ColumnPropNameInRow="CustomerCurrencyCode" msprop:Generator_ColumnPropNameInTable="CustomerCurrencyCodeColumn" msprop:Generator_UserColumnName="CustomerCurrencyCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CheckoutAttributeDescription" msprop:Generator_ColumnVarNameInTable="columnCheckoutAttributeDescription" msprop:Generator_ColumnPropNameInRow="CheckoutAttributeDescription" msprop:Generator_ColumnPropNameInTable="CheckoutAttributeDescriptionColumn" msprop:Generator_UserColumnName="CheckoutAttributeDescription">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CheckoutAttributesXML" msprop:Generator_ColumnVarNameInTable="columnCheckoutAttributesXML" msprop:Generator_ColumnPropNameInRow="CheckoutAttributesXML" msprop:Generator_ColumnPropNameInTable="CheckoutAttributesXMLColumn" msprop:Generator_UserColumnName="CheckoutAttributesXML">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OrderWeight" msprop:Generator_ColumnVarNameInTable="columnOrderWeight" msprop:Generator_ColumnPropNameInRow="OrderWeight" msprop:Generator_ColumnPropNameInTable="OrderWeightColumn" msprop:Generator_UserColumnName="OrderWeight" type="xs:decimal" />
              <xs:element name="AffiliateID" msprop:Generator_ColumnVarNameInTable="columnAffiliateID" msprop:Generator_ColumnPropNameInRow="AffiliateID" msprop:Generator_ColumnPropNameInTable="AffiliateIDColumn" msprop:Generator_UserColumnName="AffiliateID" type="xs:int" />
              <xs:element name="OrderStatusID" msprop:Generator_ColumnVarNameInTable="columnOrderStatusID" msprop:Generator_ColumnPropNameInRow="OrderStatusID" msprop:Generator_ColumnPropNameInTable="OrderStatusIDColumn" msprop:Generator_UserColumnName="OrderStatusID" type="xs:int" />
              <xs:element name="AllowStoringCreditCardNumber" msprop:Generator_ColumnVarNameInTable="columnAllowStoringCreditCardNumber" msprop:Generator_ColumnPropNameInRow="AllowStoringCreditCardNumber" msprop:Generator_ColumnPropNameInTable="AllowStoringCreditCardNumberColumn" msprop:Generator_UserColumnName="AllowStoringCreditCardNumber" type="xs:boolean" />
              <xs:element name="CardType" msprop:Generator_ColumnVarNameInTable="columnCardType" msprop:Generator_ColumnPropNameInRow="CardType" msprop:Generator_ColumnPropNameInTable="CardTypeColumn" msprop:Generator_UserColumnName="CardType">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CardName" msprop:Generator_ColumnVarNameInTable="columnCardName" msprop:Generator_ColumnPropNameInRow="CardName" msprop:Generator_ColumnPropNameInTable="CardNameColumn" msprop:Generator_UserColumnName="CardName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CardNumber" msprop:Generator_ColumnVarNameInTable="columnCardNumber" msprop:Generator_ColumnPropNameInRow="CardNumber" msprop:Generator_ColumnPropNameInTable="CardNumberColumn" msprop:Generator_UserColumnName="CardNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MaskedCreditCardNumber" msprop:Generator_ColumnVarNameInTable="columnMaskedCreditCardNumber" msprop:Generator_ColumnPropNameInRow="MaskedCreditCardNumber" msprop:Generator_ColumnPropNameInTable="MaskedCreditCardNumberColumn" msprop:Generator_UserColumnName="MaskedCreditCardNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CardCVV2" msprop:Generator_ColumnVarNameInTable="columnCardCVV2" msprop:Generator_ColumnPropNameInRow="CardCVV2" msprop:Generator_ColumnPropNameInTable="CardCVV2Column" msprop:Generator_UserColumnName="CardCVV2">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CardExpirationMonth" msprop:Generator_ColumnVarNameInTable="columnCardExpirationMonth" msprop:Generator_ColumnPropNameInRow="CardExpirationMonth" msprop:Generator_ColumnPropNameInTable="CardExpirationMonthColumn" msprop:Generator_UserColumnName="CardExpirationMonth">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CardExpirationYear" msprop:Generator_ColumnVarNameInTable="columnCardExpirationYear" msprop:Generator_ColumnPropNameInRow="CardExpirationYear" msprop:Generator_ColumnPropNameInTable="CardExpirationYearColumn" msprop:Generator_UserColumnName="CardExpirationYear">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PaymentMethodID" msprop:Generator_ColumnVarNameInTable="columnPaymentMethodID" msprop:Generator_ColumnPropNameInRow="PaymentMethodID" msprop:Generator_ColumnPropNameInTable="PaymentMethodIDColumn" msprop:Generator_UserColumnName="PaymentMethodID" type="xs:int" />
              <xs:element name="PaymentMethodName" msprop:Generator_ColumnVarNameInTable="columnPaymentMethodName" msprop:Generator_ColumnPropNameInRow="PaymentMethodName" msprop:Generator_ColumnPropNameInTable="PaymentMethodNameColumn" msprop:Generator_UserColumnName="PaymentMethodName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AuthorizationTransactionID" msprop:Generator_ColumnVarNameInTable="columnAuthorizationTransactionID" msprop:Generator_ColumnPropNameInRow="AuthorizationTransactionID" msprop:Generator_ColumnPropNameInTable="AuthorizationTransactionIDColumn" msprop:Generator_UserColumnName="AuthorizationTransactionID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AuthorizationTransactionCode" msprop:Generator_ColumnVarNameInTable="columnAuthorizationTransactionCode" msprop:Generator_ColumnPropNameInRow="AuthorizationTransactionCode" msprop:Generator_ColumnPropNameInTable="AuthorizationTransactionCodeColumn" msprop:Generator_UserColumnName="AuthorizationTransactionCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AuthorizationTransactionResult" msprop:Generator_ColumnVarNameInTable="columnAuthorizationTransactionResult" msprop:Generator_ColumnPropNameInRow="AuthorizationTransactionResult" msprop:Generator_ColumnPropNameInTable="AuthorizationTransactionResultColumn" msprop:Generator_UserColumnName="AuthorizationTransactionResult">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CaptureTransactionID" msprop:Generator_ColumnVarNameInTable="columnCaptureTransactionID" msprop:Generator_ColumnPropNameInRow="CaptureTransactionID" msprop:Generator_ColumnPropNameInTable="CaptureTransactionIDColumn" msprop:Generator_UserColumnName="CaptureTransactionID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CaptureTransactionResult" msprop:Generator_ColumnVarNameInTable="columnCaptureTransactionResult" msprop:Generator_ColumnPropNameInRow="CaptureTransactionResult" msprop:Generator_ColumnPropNameInTable="CaptureTransactionResultColumn" msprop:Generator_UserColumnName="CaptureTransactionResult">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SubscriptionTransactionID" msprop:Generator_ColumnVarNameInTable="columnSubscriptionTransactionID" msprop:Generator_ColumnPropNameInRow="SubscriptionTransactionID" msprop:Generator_ColumnPropNameInTable="SubscriptionTransactionIDColumn" msprop:Generator_UserColumnName="SubscriptionTransactionID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PurchaseOrderNumber" msprop:Generator_ColumnVarNameInTable="columnPurchaseOrderNumber" msprop:Generator_ColumnPropNameInRow="PurchaseOrderNumber" msprop:Generator_ColumnPropNameInTable="PurchaseOrderNumberColumn" msprop:Generator_UserColumnName="PurchaseOrderNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PaymentStatusID" msprop:Generator_ColumnVarNameInTable="columnPaymentStatusID" msprop:Generator_ColumnPropNameInRow="PaymentStatusID" msprop:Generator_ColumnPropNameInTable="PaymentStatusIDColumn" msprop:Generator_UserColumnName="PaymentStatusID" type="xs:int" />
              <xs:element name="PaidDate" msprop:Generator_ColumnVarNameInTable="columnPaidDate" msprop:Generator_ColumnPropNameInRow="PaidDate" msprop:Generator_ColumnPropNameInTable="PaidDateColumn" msprop:Generator_UserColumnName="PaidDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="BillingFirstName" msprop:Generator_ColumnVarNameInTable="columnBillingFirstName" msprop:Generator_ColumnPropNameInRow="BillingFirstName" msprop:Generator_ColumnPropNameInTable="BillingFirstNameColumn" msprop:Generator_UserColumnName="BillingFirstName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingLastName" msprop:Generator_ColumnVarNameInTable="columnBillingLastName" msprop:Generator_ColumnPropNameInRow="BillingLastName" msprop:Generator_ColumnPropNameInTable="BillingLastNameColumn" msprop:Generator_UserColumnName="BillingLastName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingPhoneNumber" msprop:Generator_ColumnVarNameInTable="columnBillingPhoneNumber" msprop:Generator_ColumnPropNameInRow="BillingPhoneNumber" msprop:Generator_ColumnPropNameInTable="BillingPhoneNumberColumn" msprop:Generator_UserColumnName="BillingPhoneNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingEmail" msprop:Generator_ColumnVarNameInTable="columnBillingEmail" msprop:Generator_ColumnPropNameInRow="BillingEmail" msprop:Generator_ColumnPropNameInTable="BillingEmailColumn" msprop:Generator_UserColumnName="BillingEmail">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingFaxNumber" msprop:Generator_ColumnVarNameInTable="columnBillingFaxNumber" msprop:Generator_ColumnPropNameInRow="BillingFaxNumber" msprop:Generator_ColumnPropNameInTable="BillingFaxNumberColumn" msprop:Generator_UserColumnName="BillingFaxNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingCompany" msprop:Generator_ColumnVarNameInTable="columnBillingCompany" msprop:Generator_ColumnPropNameInRow="BillingCompany" msprop:Generator_ColumnPropNameInTable="BillingCompanyColumn" msprop:Generator_UserColumnName="BillingCompany">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingAddress1" msprop:Generator_ColumnVarNameInTable="columnBillingAddress1" msprop:Generator_ColumnPropNameInRow="BillingAddress1" msprop:Generator_ColumnPropNameInTable="BillingAddress1Column" msprop:Generator_UserColumnName="BillingAddress1">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingAddress2" msprop:Generator_ColumnVarNameInTable="columnBillingAddress2" msprop:Generator_ColumnPropNameInRow="BillingAddress2" msprop:Generator_ColumnPropNameInTable="BillingAddress2Column" msprop:Generator_UserColumnName="BillingAddress2">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingCity" msprop:Generator_ColumnVarNameInTable="columnBillingCity" msprop:Generator_ColumnPropNameInRow="BillingCity" msprop:Generator_ColumnPropNameInTable="BillingCityColumn" msprop:Generator_UserColumnName="BillingCity">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingStateProvince" msprop:Generator_ColumnVarNameInTable="columnBillingStateProvince" msprop:Generator_ColumnPropNameInRow="BillingStateProvince" msprop:Generator_ColumnPropNameInTable="BillingStateProvinceColumn" msprop:Generator_UserColumnName="BillingStateProvince">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingStateProvinceID" msprop:Generator_ColumnVarNameInTable="columnBillingStateProvinceID" msprop:Generator_ColumnPropNameInRow="BillingStateProvinceID" msprop:Generator_ColumnPropNameInTable="BillingStateProvinceIDColumn" msprop:Generator_UserColumnName="BillingStateProvinceID" type="xs:int" />
              <xs:element name="BillingZipPostalCode" msprop:Generator_ColumnVarNameInTable="columnBillingZipPostalCode" msprop:Generator_ColumnPropNameInRow="BillingZipPostalCode" msprop:Generator_ColumnPropNameInTable="BillingZipPostalCodeColumn" msprop:Generator_UserColumnName="BillingZipPostalCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingCountry" msprop:Generator_ColumnVarNameInTable="columnBillingCountry" msprop:Generator_ColumnPropNameInRow="BillingCountry" msprop:Generator_ColumnPropNameInTable="BillingCountryColumn" msprop:Generator_UserColumnName="BillingCountry">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BillingCountryID" msprop:Generator_ColumnVarNameInTable="columnBillingCountryID" msprop:Generator_ColumnPropNameInRow="BillingCountryID" msprop:Generator_ColumnPropNameInTable="BillingCountryIDColumn" msprop:Generator_UserColumnName="BillingCountryID" type="xs:int" />
              <xs:element name="ShippingStatusID" msprop:Generator_ColumnVarNameInTable="columnShippingStatusID" msprop:Generator_ColumnPropNameInRow="ShippingStatusID" msprop:Generator_ColumnPropNameInTable="ShippingStatusIDColumn" msprop:Generator_UserColumnName="ShippingStatusID" type="xs:int" />
              <xs:element name="ShippingFirstName" msprop:Generator_ColumnVarNameInTable="columnShippingFirstName" msprop:Generator_ColumnPropNameInRow="ShippingFirstName" msprop:Generator_ColumnPropNameInTable="ShippingFirstNameColumn" msprop:Generator_UserColumnName="ShippingFirstName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingLastName" msprop:Generator_ColumnVarNameInTable="columnShippingLastName" msprop:Generator_ColumnPropNameInRow="ShippingLastName" msprop:Generator_ColumnPropNameInTable="ShippingLastNameColumn" msprop:Generator_UserColumnName="ShippingLastName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingPhoneNumber" msprop:Generator_ColumnVarNameInTable="columnShippingPhoneNumber" msprop:Generator_ColumnPropNameInRow="ShippingPhoneNumber" msprop:Generator_ColumnPropNameInTable="ShippingPhoneNumberColumn" msprop:Generator_UserColumnName="ShippingPhoneNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingEmail" msprop:Generator_ColumnVarNameInTable="columnShippingEmail" msprop:Generator_ColumnPropNameInRow="ShippingEmail" msprop:Generator_ColumnPropNameInTable="ShippingEmailColumn" msprop:Generator_UserColumnName="ShippingEmail">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingFaxNumber" msprop:Generator_ColumnVarNameInTable="columnShippingFaxNumber" msprop:Generator_ColumnPropNameInRow="ShippingFaxNumber" msprop:Generator_ColumnPropNameInTable="ShippingFaxNumberColumn" msprop:Generator_UserColumnName="ShippingFaxNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingCompany" msprop:Generator_ColumnVarNameInTable="columnShippingCompany" msprop:Generator_ColumnPropNameInRow="ShippingCompany" msprop:Generator_ColumnPropNameInTable="ShippingCompanyColumn" msprop:Generator_UserColumnName="ShippingCompany">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingAddress1" msprop:Generator_ColumnVarNameInTable="columnShippingAddress1" msprop:Generator_ColumnPropNameInRow="ShippingAddress1" msprop:Generator_ColumnPropNameInTable="ShippingAddress1Column" msprop:Generator_UserColumnName="ShippingAddress1">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingAddress2" msprop:Generator_ColumnVarNameInTable="columnShippingAddress2" msprop:Generator_ColumnPropNameInRow="ShippingAddress2" msprop:Generator_ColumnPropNameInTable="ShippingAddress2Column" msprop:Generator_UserColumnName="ShippingAddress2">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingCity" msprop:Generator_ColumnVarNameInTable="columnShippingCity" msprop:Generator_ColumnPropNameInRow="ShippingCity" msprop:Generator_ColumnPropNameInTable="ShippingCityColumn" msprop:Generator_UserColumnName="ShippingCity">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingStateProvince" msprop:Generator_ColumnVarNameInTable="columnShippingStateProvince" msprop:Generator_ColumnPropNameInRow="ShippingStateProvince" msprop:Generator_ColumnPropNameInTable="ShippingStateProvinceColumn" msprop:Generator_UserColumnName="ShippingStateProvince">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingStateProvinceID" msprop:Generator_ColumnVarNameInTable="columnShippingStateProvinceID" msprop:Generator_ColumnPropNameInRow="ShippingStateProvinceID" msprop:Generator_ColumnPropNameInTable="ShippingStateProvinceIDColumn" msprop:Generator_UserColumnName="ShippingStateProvinceID" type="xs:int" />
              <xs:element name="ShippingZipPostalCode" msprop:Generator_ColumnVarNameInTable="columnShippingZipPostalCode" msprop:Generator_ColumnPropNameInRow="ShippingZipPostalCode" msprop:Generator_ColumnPropNameInTable="ShippingZipPostalCodeColumn" msprop:Generator_UserColumnName="ShippingZipPostalCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingCountry" msprop:Generator_ColumnVarNameInTable="columnShippingCountry" msprop:Generator_ColumnPropNameInRow="ShippingCountry" msprop:Generator_ColumnPropNameInTable="ShippingCountryColumn" msprop:Generator_UserColumnName="ShippingCountry">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingCountryID" msprop:Generator_ColumnVarNameInTable="columnShippingCountryID" msprop:Generator_ColumnPropNameInRow="ShippingCountryID" msprop:Generator_ColumnPropNameInTable="ShippingCountryIDColumn" msprop:Generator_UserColumnName="ShippingCountryID" type="xs:int" />
              <xs:element name="ShippingMethod" msprop:Generator_ColumnVarNameInTable="columnShippingMethod" msprop:Generator_ColumnPropNameInRow="ShippingMethod" msprop:Generator_ColumnPropNameInTable="ShippingMethodColumn" msprop:Generator_UserColumnName="ShippingMethod">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShippingRateComputationMethodID" msprop:Generator_ColumnVarNameInTable="columnShippingRateComputationMethodID" msprop:Generator_ColumnPropNameInRow="ShippingRateComputationMethodID" msprop:Generator_ColumnPropNameInTable="ShippingRateComputationMethodIDColumn" msprop:Generator_UserColumnName="ShippingRateComputationMethodID" type="xs:int" />
              <xs:element name="ShippedDate" msprop:Generator_ColumnVarNameInTable="columnShippedDate" msprop:Generator_ColumnPropNameInRow="ShippedDate" msprop:Generator_ColumnPropNameInTable="ShippedDateColumn" msprop:Generator_UserColumnName="ShippedDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="TrackingNumber" msprop:Generator_ColumnVarNameInTable="columnTrackingNumber" msprop:Generator_ColumnPropNameInRow="TrackingNumber" msprop:Generator_ColumnPropNameInTable="TrackingNumberColumn" msprop:Generator_UserColumnName="TrackingNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DeliveryDate" msprop:Generator_ColumnVarNameInTable="columnDeliveryDate" msprop:Generator_ColumnPropNameInRow="DeliveryDate" msprop:Generator_ColumnPropNameInTable="DeliveryDateColumn" msprop:Generator_UserColumnName="DeliveryDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="VatNumber" msprop:Generator_ColumnVarNameInTable="columnVatNumber" msprop:Generator_ColumnPropNameInRow="VatNumber" msprop:Generator_ColumnPropNameInTable="VatNumberColumn" msprop:Generator_UserColumnName="VatNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Deleted" msprop:Generator_ColumnVarNameInTable="columnDeleted" msprop:Generator_ColumnPropNameInRow="Deleted" msprop:Generator_ColumnPropNameInTable="DeletedColumn" msprop:Generator_UserColumnName="Deleted" type="xs:boolean" />
              <xs:element name="CreatedOn" msprop:Generator_ColumnVarNameInTable="columnCreatedOn" msprop:Generator_ColumnPropNameInRow="CreatedOn" msprop:Generator_ColumnPropNameInTable="CreatedOnColumn" msprop:Generator_UserColumnName="CreatedOn" type="xs:dateTime" />
              <xs:element name="OrderProductVariantID" msprop:Generator_ColumnVarNameInTable="columnOrderProductVariantID" msprop:Generator_ColumnPropNameInRow="OrderProductVariantID" msprop:Generator_ColumnPropNameInTable="OrderProductVariantIDColumn" msprop:Generator_UserColumnName="OrderProductVariantID" type="xs:int" />
              <xs:element name="ProductVariantID" msprop:Generator_ColumnVarNameInTable="columnProductVariantID" msprop:Generator_ColumnPropNameInRow="ProductVariantID" msprop:Generator_ColumnPropNameInTable="ProductVariantIDColumn" msprop:Generator_UserColumnName="ProductVariantID" type="xs:int" />
              <xs:element name="UnitPriceInclTax" msprop:Generator_ColumnVarNameInTable="columnUnitPriceInclTax" msprop:Generator_ColumnPropNameInRow="UnitPriceInclTax" msprop:Generator_ColumnPropNameInTable="UnitPriceInclTaxColumn" msprop:Generator_UserColumnName="UnitPriceInclTax" type="xs:decimal" />
              <xs:element name="UnitPriceExclTax" msprop:Generator_ColumnVarNameInTable="columnUnitPriceExclTax" msprop:Generator_ColumnPropNameInRow="UnitPriceExclTax" msprop:Generator_ColumnPropNameInTable="UnitPriceExclTaxColumn" msprop:Generator_UserColumnName="UnitPriceExclTax" type="xs:decimal" />
              <xs:element name="PriceInclTax" msprop:Generator_ColumnVarNameInTable="columnPriceInclTax" msprop:Generator_ColumnPropNameInRow="PriceInclTax" msprop:Generator_ColumnPropNameInTable="PriceInclTaxColumn" msprop:Generator_UserColumnName="PriceInclTax" type="xs:decimal" />
              <xs:element name="PriceExclTax" msprop:Generator_ColumnVarNameInTable="columnPriceExclTax" msprop:Generator_ColumnPropNameInRow="PriceExclTax" msprop:Generator_ColumnPropNameInTable="PriceExclTaxColumn" msprop:Generator_UserColumnName="PriceExclTax" type="xs:decimal" />
              <xs:element name="UnitPriceInclTaxInCustomerCurrency" msprop:Generator_ColumnVarNameInTable="columnUnitPriceInclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInRow="UnitPriceInclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInTable="UnitPriceInclTaxInCustomerCurrencyColumn" msprop:Generator_UserColumnName="UnitPriceInclTaxInCustomerCurrency" type="xs:decimal" />
              <xs:element name="UnitPriceExclTaxInCustomerCurrency" msprop:Generator_ColumnVarNameInTable="columnUnitPriceExclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInRow="UnitPriceExclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInTable="UnitPriceExclTaxInCustomerCurrencyColumn" msprop:Generator_UserColumnName="UnitPriceExclTaxInCustomerCurrency" type="xs:decimal" />
              <xs:element name="PriceInclTaxInCustomerCurrency" msprop:Generator_ColumnVarNameInTable="columnPriceInclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInRow="PriceInclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInTable="PriceInclTaxInCustomerCurrencyColumn" msprop:Generator_UserColumnName="PriceInclTaxInCustomerCurrency" type="xs:decimal" />
              <xs:element name="PriceExclTaxInCustomerCurrency" msprop:Generator_ColumnVarNameInTable="columnPriceExclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInRow="PriceExclTaxInCustomerCurrency" msprop:Generator_ColumnPropNameInTable="PriceExclTaxInCustomerCurrencyColumn" msprop:Generator_UserColumnName="PriceExclTaxInCustomerCurrency" type="xs:decimal" />
              <xs:element name="AttributeDescription" msprop:Generator_ColumnVarNameInTable="columnAttributeDescription" msprop:Generator_ColumnPropNameInRow="AttributeDescription" msprop:Generator_ColumnPropNameInTable="AttributeDescriptionColumn" msprop:Generator_UserColumnName="AttributeDescription">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AttributesXML" msprop:Generator_ColumnVarNameInTable="columnAttributesXML" msprop:Generator_ColumnPropNameInRow="AttributesXML" msprop:Generator_ColumnPropNameInTable="AttributesXMLColumn" msprop:Generator_UserColumnName="AttributesXML">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Quantity" msprop:Generator_ColumnVarNameInTable="columnQuantity" msprop:Generator_ColumnPropNameInRow="Quantity" msprop:Generator_ColumnPropNameInTable="QuantityColumn" msprop:Generator_UserColumnName="Quantity" type="xs:int" />
              <xs:element name="DiscountAmountInclTax" msprop:Generator_ColumnVarNameInTable="columnDiscountAmountInclTax" msprop:Generator_ColumnPropNameInRow="DiscountAmountInclTax" msprop:Generator_ColumnPropNameInTable="DiscountAmountInclTaxColumn" msprop:Generator_UserColumnName="DiscountAmountInclTax" type="xs:decimal" />
              <xs:element name="DiscountAmountExclTax" msprop:Generator_ColumnVarNameInTable="columnDiscountAmountExclTax" msprop:Generator_ColumnPropNameInRow="DiscountAmountExclTax" msprop:Generator_ColumnPropNameInTable="DiscountAmountExclTaxColumn" msprop:Generator_UserColumnName="DiscountAmountExclTax" type="xs:decimal" />
              <xs:element name="DownloadCount" msprop:Generator_ColumnVarNameInTable="columnDownloadCount" msprop:Generator_ColumnPropNameInRow="DownloadCount" msprop:Generator_ColumnPropNameInTable="DownloadCountColumn" msprop:Generator_UserColumnName="DownloadCount" type="xs:int" />
              <xs:element name="OrderProductVariantGUID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnOrderProductVariantGUID" msprop:Generator_ColumnPropNameInRow="OrderProductVariantGUID" msprop:Generator_ColumnPropNameInTable="OrderProductVariantGUIDColumn" msprop:Generator_UserColumnName="OrderProductVariantGUID" type="xs:string" />
              <xs:element name="IsDownloadActivated" msprop:Generator_ColumnVarNameInTable="columnIsDownloadActivated" msprop:Generator_ColumnPropNameInRow="IsDownloadActivated" msprop:Generator_ColumnPropNameInTable="IsDownloadActivatedColumn" msprop:Generator_UserColumnName="IsDownloadActivated" type="xs:boolean" />
              <xs:element name="LicenseDownloadID" msprop:Generator_ColumnVarNameInTable="columnLicenseDownloadID" msprop:Generator_ColumnPropNameInRow="LicenseDownloadID" msprop:Generator_ColumnPropNameInTable="LicenseDownloadIDColumn" msprop:Generator_UserColumnName="LicenseDownloadID" type="xs:int" />
              <xs:element name="ProductID" msprop:Generator_ColumnVarNameInTable="columnProductID" msprop:Generator_ColumnPropNameInRow="ProductID" msprop:Generator_ColumnPropNameInTable="ProductIDColumn" msprop:Generator_UserColumnName="ProductID" type="xs:int" />
              <xs:element name="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" msprop:Generator_UserColumnName="Name">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="400" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SKU" msprop:Generator_ColumnVarNameInTable="columnSKU" msprop:Generator_ColumnPropNameInRow="SKU" msprop:Generator_ColumnPropNameInTable="SKUColumn" msprop:Generator_UserColumnName="SKU">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Description" msprop:Generator_ColumnVarNameInTable="columnDescription" msprop:Generator_ColumnPropNameInRow="Description" msprop:Generator_ColumnPropNameInTable="DescriptionColumn" msprop:Generator_UserColumnName="Description">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AdminComment" msprop:Generator_ColumnVarNameInTable="columnAdminComment" msprop:Generator_ColumnPropNameInRow="AdminComment" msprop:Generator_ColumnPropNameInTable="AdminCommentColumn" msprop:Generator_UserColumnName="AdminComment">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ManufacturerPartNumber" msprop:Generator_ColumnVarNameInTable="columnManufacturerPartNumber" msprop:Generator_ColumnPropNameInRow="ManufacturerPartNumber" msprop:Generator_ColumnPropNameInTable="ManufacturerPartNumberColumn" msprop:Generator_UserColumnName="ManufacturerPartNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsGiftCard" msprop:Generator_ColumnVarNameInTable="columnIsGiftCard" msprop:Generator_ColumnPropNameInRow="IsGiftCard" msprop:Generator_ColumnPropNameInTable="IsGiftCardColumn" msprop:Generator_UserColumnName="IsGiftCard" type="xs:boolean" />
              <xs:element name="GiftCardType" msprop:Generator_ColumnVarNameInTable="columnGiftCardType" msprop:Generator_ColumnPropNameInRow="GiftCardType" msprop:Generator_ColumnPropNameInTable="GiftCardTypeColumn" msprop:Generator_UserColumnName="GiftCardType" type="xs:int" />
              <xs:element name="IsDownload" msprop:Generator_ColumnVarNameInTable="columnIsDownload" msprop:Generator_ColumnPropNameInRow="IsDownload" msprop:Generator_ColumnPropNameInTable="IsDownloadColumn" msprop:Generator_UserColumnName="IsDownload" type="xs:boolean" />
              <xs:element name="DownloadID" msprop:Generator_ColumnVarNameInTable="columnDownloadID" msprop:Generator_ColumnPropNameInRow="DownloadID" msprop:Generator_ColumnPropNameInTable="DownloadIDColumn" msprop:Generator_UserColumnName="DownloadID" type="xs:int" />
              <xs:element name="UnlimitedDownloads" msprop:Generator_ColumnVarNameInTable="columnUnlimitedDownloads" msprop:Generator_ColumnPropNameInRow="UnlimitedDownloads" msprop:Generator_ColumnPropNameInTable="UnlimitedDownloadsColumn" msprop:Generator_UserColumnName="UnlimitedDownloads" type="xs:boolean" />
              <xs:element name="MaxNumberOfDownloads" msprop:Generator_ColumnVarNameInTable="columnMaxNumberOfDownloads" msprop:Generator_ColumnPropNameInRow="MaxNumberOfDownloads" msprop:Generator_ColumnPropNameInTable="MaxNumberOfDownloadsColumn" msprop:Generator_UserColumnName="MaxNumberOfDownloads" type="xs:int" />
              <xs:element name="DownloadExpirationDays" msprop:Generator_ColumnVarNameInTable="columnDownloadExpirationDays" msprop:Generator_ColumnPropNameInRow="DownloadExpirationDays" msprop:Generator_ColumnPropNameInTable="DownloadExpirationDaysColumn" msprop:Generator_UserColumnName="DownloadExpirationDays" type="xs:int" minOccurs="0" />
              <xs:element name="DownloadActivationType" msprop:Generator_ColumnVarNameInTable="columnDownloadActivationType" msprop:Generator_ColumnPropNameInRow="DownloadActivationType" msprop:Generator_ColumnPropNameInTable="DownloadActivationTypeColumn" msprop:Generator_UserColumnName="DownloadActivationType" type="xs:int" />
              <xs:element name="HasSampleDownload" msprop:Generator_ColumnVarNameInTable="columnHasSampleDownload" msprop:Generator_ColumnPropNameInRow="HasSampleDownload" msprop:Generator_ColumnPropNameInTable="HasSampleDownloadColumn" msprop:Generator_UserColumnName="HasSampleDownload" type="xs:boolean" />
              <xs:element name="SampleDownloadID" msprop:Generator_ColumnVarNameInTable="columnSampleDownloadID" msprop:Generator_ColumnPropNameInRow="SampleDownloadID" msprop:Generator_ColumnPropNameInTable="SampleDownloadIDColumn" msprop:Generator_UserColumnName="SampleDownloadID" type="xs:int" />
              <xs:element name="HasUserAgreement" msprop:Generator_ColumnVarNameInTable="columnHasUserAgreement" msprop:Generator_ColumnPropNameInRow="HasUserAgreement" msprop:Generator_ColumnPropNameInTable="HasUserAgreementColumn" msprop:Generator_UserColumnName="HasUserAgreement" type="xs:boolean" />
              <xs:element name="UserAgreementText" msprop:Generator_ColumnVarNameInTable="columnUserAgreementText" msprop:Generator_ColumnPropNameInRow="UserAgreementText" msprop:Generator_ColumnPropNameInTable="UserAgreementTextColumn" msprop:Generator_UserColumnName="UserAgreementText">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IsRecurring" msprop:Generator_ColumnVarNameInTable="columnIsRecurring" msprop:Generator_ColumnPropNameInRow="IsRecurring" msprop:Generator_ColumnPropNameInTable="IsRecurringColumn" msprop:Generator_UserColumnName="IsRecurring" type="xs:boolean" />
              <xs:element name="CycleLength" msprop:Generator_ColumnVarNameInTable="columnCycleLength" msprop:Generator_ColumnPropNameInRow="CycleLength" msprop:Generator_ColumnPropNameInTable="CycleLengthColumn" msprop:Generator_UserColumnName="CycleLength" type="xs:int" />
              <xs:element name="CyclePeriod" msprop:Generator_ColumnVarNameInTable="columnCyclePeriod" msprop:Generator_ColumnPropNameInRow="CyclePeriod" msprop:Generator_ColumnPropNameInTable="CyclePeriodColumn" msprop:Generator_UserColumnName="CyclePeriod" type="xs:int" />
              <xs:element name="TotalCycles" msprop:Generator_ColumnVarNameInTable="columnTotalCycles" msprop:Generator_ColumnPropNameInRow="TotalCycles" msprop:Generator_ColumnPropNameInTable="TotalCyclesColumn" msprop:Generator_UserColumnName="TotalCycles" type="xs:int" />
              <xs:element name="IsShipEnabled" msprop:Generator_ColumnVarNameInTable="columnIsShipEnabled" msprop:Generator_ColumnPropNameInRow="IsShipEnabled" msprop:Generator_ColumnPropNameInTable="IsShipEnabledColumn" msprop:Generator_UserColumnName="IsShipEnabled" type="xs:boolean" />
              <xs:element name="IsFreeShipping" msprop:Generator_ColumnVarNameInTable="columnIsFreeShipping" msprop:Generator_ColumnPropNameInRow="IsFreeShipping" msprop:Generator_ColumnPropNameInTable="IsFreeShippingColumn" msprop:Generator_UserColumnName="IsFreeShipping" type="xs:boolean" />
              <xs:element name="AdditionalShippingCharge" msprop:Generator_ColumnVarNameInTable="columnAdditionalShippingCharge" msprop:Generator_ColumnPropNameInRow="AdditionalShippingCharge" msprop:Generator_ColumnPropNameInTable="AdditionalShippingChargeColumn" msprop:Generator_UserColumnName="AdditionalShippingCharge" type="xs:decimal" />
              <xs:element name="IsTaxExempt" msprop:Generator_ColumnVarNameInTable="columnIsTaxExempt" msprop:Generator_ColumnPropNameInRow="IsTaxExempt" msprop:Generator_ColumnPropNameInTable="IsTaxExemptColumn" msprop:Generator_UserColumnName="IsTaxExempt" type="xs:boolean" />
              <xs:element name="TaxCategoryID" msprop:Generator_ColumnVarNameInTable="columnTaxCategoryID" msprop:Generator_ColumnPropNameInRow="TaxCategoryID" msprop:Generator_ColumnPropNameInTable="TaxCategoryIDColumn" msprop:Generator_UserColumnName="TaxCategoryID" type="xs:int" />
              <xs:element name="ManageInventory" msprop:Generator_ColumnVarNameInTable="columnManageInventory" msprop:Generator_ColumnPropNameInRow="ManageInventory" msprop:Generator_ColumnPropNameInTable="ManageInventoryColumn" msprop:Generator_UserColumnName="ManageInventory" type="xs:int" />
              <xs:element name="StockQuantity" msprop:Generator_ColumnVarNameInTable="columnStockQuantity" msprop:Generator_ColumnPropNameInRow="StockQuantity" msprop:Generator_ColumnPropNameInTable="StockQuantityColumn" msprop:Generator_UserColumnName="StockQuantity" type="xs:int" />
              <xs:element name="DisplayStockAvailability" msprop:Generator_ColumnVarNameInTable="columnDisplayStockAvailability" msprop:Generator_ColumnPropNameInRow="DisplayStockAvailability" msprop:Generator_ColumnPropNameInTable="DisplayStockAvailabilityColumn" msprop:Generator_UserColumnName="DisplayStockAvailability" type="xs:boolean" />
              <xs:element name="DisplayStockQuantity" msprop:Generator_ColumnVarNameInTable="columnDisplayStockQuantity" msprop:Generator_ColumnPropNameInRow="DisplayStockQuantity" msprop:Generator_ColumnPropNameInTable="DisplayStockQuantityColumn" msprop:Generator_UserColumnName="DisplayStockQuantity" type="xs:boolean" />
              <xs:element name="MinStockQuantity" msprop:Generator_ColumnVarNameInTable="columnMinStockQuantity" msprop:Generator_ColumnPropNameInRow="MinStockQuantity" msprop:Generator_ColumnPropNameInTable="MinStockQuantityColumn" msprop:Generator_UserColumnName="MinStockQuantity" type="xs:int" />
              <xs:element name="LowStockActivityID" msprop:Generator_ColumnVarNameInTable="columnLowStockActivityID" msprop:Generator_ColumnPropNameInRow="LowStockActivityID" msprop:Generator_ColumnPropNameInTable="LowStockActivityIDColumn" msprop:Generator_UserColumnName="LowStockActivityID" type="xs:int" />
              <xs:element name="NotifyAdminForQuantityBelow" msprop:Generator_ColumnVarNameInTable="columnNotifyAdminForQuantityBelow" msprop:Generator_ColumnPropNameInRow="NotifyAdminForQuantityBelow" msprop:Generator_ColumnPropNameInTable="NotifyAdminForQuantityBelowColumn" msprop:Generator_UserColumnName="NotifyAdminForQuantityBelow" type="xs:int" />
              <xs:element name="Backorders" msprop:Generator_ColumnVarNameInTable="columnBackorders" msprop:Generator_ColumnPropNameInRow="Backorders" msprop:Generator_ColumnPropNameInTable="BackordersColumn" msprop:Generator_UserColumnName="Backorders" type="xs:int" />
              <xs:element name="OrderMinimumQuantity" msprop:Generator_ColumnVarNameInTable="columnOrderMinimumQuantity" msprop:Generator_ColumnPropNameInRow="OrderMinimumQuantity" msprop:Generator_ColumnPropNameInTable="OrderMinimumQuantityColumn" msprop:Generator_UserColumnName="OrderMinimumQuantity" type="xs:int" />
              <xs:element name="OrderMaximumQuantity" msprop:Generator_ColumnVarNameInTable="columnOrderMaximumQuantity" msprop:Generator_ColumnPropNameInRow="OrderMaximumQuantity" msprop:Generator_ColumnPropNameInTable="OrderMaximumQuantityColumn" msprop:Generator_UserColumnName="OrderMaximumQuantity" type="xs:int" />
              <xs:element name="WarehouseID" msprop:Generator_ColumnVarNameInTable="columnWarehouseID" msprop:Generator_ColumnPropNameInRow="WarehouseID" msprop:Generator_ColumnPropNameInTable="WarehouseIDColumn" msprop:Generator_UserColumnName="WarehouseID" type="xs:int" />
              <xs:element name="DisableBuyButton" msprop:Generator_ColumnVarNameInTable="columnDisableBuyButton" msprop:Generator_ColumnPropNameInRow="DisableBuyButton" msprop:Generator_ColumnPropNameInTable="DisableBuyButtonColumn" msprop:Generator_UserColumnName="DisableBuyButton" type="xs:boolean" />
              <xs:element name="CallForPrice" msprop:Generator_ColumnVarNameInTable="columnCallForPrice" msprop:Generator_ColumnPropNameInRow="CallForPrice" msprop:Generator_ColumnPropNameInTable="CallForPriceColumn" msprop:Generator_UserColumnName="CallForPrice" type="xs:boolean" />
              <xs:element name="Price" msprop:Generator_ColumnVarNameInTable="columnPrice" msprop:Generator_ColumnPropNameInRow="Price" msprop:Generator_ColumnPropNameInTable="PriceColumn" msprop:Generator_UserColumnName="Price" type="xs:decimal" />
              <xs:element name="OldPrice" msprop:Generator_ColumnVarNameInTable="columnOldPrice" msprop:Generator_ColumnPropNameInRow="OldPrice" msprop:Generator_ColumnPropNameInTable="OldPriceColumn" msprop:Generator_UserColumnName="OldPrice" type="xs:decimal" />
              <xs:element name="ProductCost" msprop:Generator_ColumnVarNameInTable="columnProductCost" msprop:Generator_ColumnPropNameInRow="ProductCost" msprop:Generator_ColumnPropNameInTable="ProductCostColumn" msprop:Generator_UserColumnName="ProductCost" type="xs:decimal" />
              <xs:element name="CustomerEntersPrice" msprop:Generator_ColumnVarNameInTable="columnCustomerEntersPrice" msprop:Generator_ColumnPropNameInRow="CustomerEntersPrice" msprop:Generator_ColumnPropNameInTable="CustomerEntersPriceColumn" msprop:Generator_UserColumnName="CustomerEntersPrice" type="xs:boolean" />
              <xs:element name="MinimumCustomerEnteredPrice" msprop:Generator_ColumnVarNameInTable="columnMinimumCustomerEnteredPrice" msprop:Generator_ColumnPropNameInRow="MinimumCustomerEnteredPrice" msprop:Generator_ColumnPropNameInTable="MinimumCustomerEnteredPriceColumn" msprop:Generator_UserColumnName="MinimumCustomerEnteredPrice" type="xs:decimal" />
              <xs:element name="MaximumCustomerEnteredPrice" msprop:Generator_ColumnVarNameInTable="columnMaximumCustomerEnteredPrice" msprop:Generator_ColumnPropNameInRow="MaximumCustomerEnteredPrice" msprop:Generator_ColumnPropNameInTable="MaximumCustomerEnteredPriceColumn" msprop:Generator_UserColumnName="MaximumCustomerEnteredPrice" type="xs:decimal" />
              <xs:element name="Weight" msprop:Generator_ColumnVarNameInTable="columnWeight" msprop:Generator_ColumnPropNameInRow="Weight" msprop:Generator_ColumnPropNameInTable="WeightColumn" msprop:Generator_UserColumnName="Weight" type="xs:decimal" />
              <xs:element name="Length" msprop:Generator_ColumnVarNameInTable="columnLength" msprop:Generator_ColumnPropNameInRow="Length" msprop:Generator_ColumnPropNameInTable="LengthColumn" msprop:Generator_UserColumnName="Length" type="xs:decimal" />
              <xs:element name="Width" msprop:Generator_ColumnVarNameInTable="columnWidth" msprop:Generator_ColumnPropNameInRow="Width" msprop:Generator_ColumnPropNameInTable="WidthColumn" msprop:Generator_UserColumnName="Width" type="xs:decimal" />
              <xs:element name="Height" msprop:Generator_ColumnVarNameInTable="columnHeight" msprop:Generator_ColumnPropNameInRow="Height" msprop:Generator_ColumnPropNameInTable="HeightColumn" msprop:Generator_UserColumnName="Height" type="xs:decimal" />
              <xs:element name="PictureID" msprop:Generator_ColumnVarNameInTable="columnPictureID" msprop:Generator_ColumnPropNameInRow="PictureID" msprop:Generator_ColumnPropNameInTable="PictureIDColumn" msprop:Generator_UserColumnName="PictureID" type="xs:int" />
              <xs:element name="AvailableStartDateTime" msprop:Generator_ColumnVarNameInTable="columnAvailableStartDateTime" msprop:Generator_ColumnPropNameInRow="AvailableStartDateTime" msprop:Generator_ColumnPropNameInTable="AvailableStartDateTimeColumn" msprop:Generator_UserColumnName="AvailableStartDateTime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="AvailableEndDateTime" msprop:Generator_ColumnVarNameInTable="columnAvailableEndDateTime" msprop:Generator_ColumnPropNameInRow="AvailableEndDateTime" msprop:Generator_ColumnPropNameInTable="AvailableEndDateTimeColumn" msprop:Generator_UserColumnName="AvailableEndDateTime" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Published" msprop:Generator_ColumnVarNameInTable="columnPublished" msprop:Generator_ColumnPropNameInRow="Published" msprop:Generator_ColumnPropNameInTable="PublishedColumn" msprop:Generator_UserColumnName="Published" type="xs:boolean" />
              <xs:element name="DisplayOrder" msprop:Generator_ColumnVarNameInTable="columnDisplayOrder" msprop:Generator_ColumnPropNameInRow="DisplayOrder" msprop:Generator_ColumnPropNameInTable="DisplayOrderColumn" msprop:Generator_UserColumnName="DisplayOrder" type="xs:int" />
              <xs:element name="UpdatedOn" msprop:Generator_ColumnVarNameInTable="columnUpdatedOn" msprop:Generator_ColumnPropNameInRow="UpdatedOn" msprop:Generator_ColumnPropNameInTable="UpdatedOnColumn" msprop:Generator_UserColumnName="UpdatedOn" type="xs:dateTime" />
              <xs:element name="ProductName" msprop:Generator_ColumnVarNameInTable="columnProductName" msprop:Generator_ColumnPropNameInRow="ProductName" msprop:Generator_ColumnPropNameInTable="ProductNameColumn" msprop:Generator_UserColumnName="ProductName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="400" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ShortDescription" msprop:Generator_ColumnVarNameInTable="columnShortDescription" msprop:Generator_ColumnPropNameInRow="ShortDescription" msprop:Generator_ColumnPropNameInTable="ShortDescriptionColumn" msprop:Generator_UserColumnName="ShortDescription">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FullDescription" msprop:Generator_ColumnVarNameInTable="columnFullDescription" msprop:Generator_ColumnPropNameInRow="FullDescription" msprop:Generator_ColumnPropNameInTable="FullDescriptionColumn" msprop:Generator_UserColumnName="FullDescription">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TemplateID" msprop:Generator_ColumnVarNameInTable="columnTemplateID" msprop:Generator_ColumnPropNameInRow="TemplateID" msprop:Generator_ColumnPropNameInTable="TemplateIDColumn" msprop:Generator_UserColumnName="TemplateID" type="xs:int" />
              <xs:element name="ShowOnHomePage" msprop:Generator_ColumnVarNameInTable="columnShowOnHomePage" msprop:Generator_ColumnPropNameInRow="ShowOnHomePage" msprop:Generator_ColumnPropNameInTable="ShowOnHomePageColumn" msprop:Generator_UserColumnName="ShowOnHomePage" type="xs:boolean" />
              <xs:element name="MetaKeywords" msprop:Generator_ColumnVarNameInTable="columnMetaKeywords" msprop:Generator_ColumnPropNameInRow="MetaKeywords" msprop:Generator_ColumnPropNameInTable="MetaKeywordsColumn" msprop:Generator_UserColumnName="MetaKeywords">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="400" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MetaDescription" msprop:Generator_ColumnVarNameInTable="columnMetaDescription" msprop:Generator_ColumnPropNameInRow="MetaDescription" msprop:Generator_ColumnPropNameInTable="MetaDescriptionColumn" msprop:Generator_UserColumnName="MetaDescription">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MetaTitle" msprop:Generator_ColumnVarNameInTable="columnMetaTitle" msprop:Generator_ColumnPropNameInRow="MetaTitle" msprop:Generator_ColumnPropNameInTable="MetaTitleColumn" msprop:Generator_UserColumnName="MetaTitle">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="400" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SEName" msprop:Generator_ColumnVarNameInTable="columnSEName" msprop:Generator_ColumnPropNameInRow="SEName" msprop:Generator_ColumnPropNameInTable="SENameColumn" msprop:Generator_UserColumnName="SEName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AllowCustomerReviews" msprop:Generator_ColumnVarNameInTable="columnAllowCustomerReviews" msprop:Generator_ColumnPropNameInRow="AllowCustomerReviews" msprop:Generator_ColumnPropNameInTable="AllowCustomerReviewsColumn" msprop:Generator_UserColumnName="AllowCustomerReviews" type="xs:boolean" />
              <xs:element name="AllowCustomerRatings" msprop:Generator_ColumnVarNameInTable="columnAllowCustomerRatings" msprop:Generator_ColumnPropNameInRow="AllowCustomerRatings" msprop:Generator_ColumnPropNameInTable="AllowCustomerRatingsColumn" msprop:Generator_UserColumnName="AllowCustomerRatings" type="xs:boolean" />
              <xs:element name="RatingSum" msprop:Generator_ColumnVarNameInTable="columnRatingSum" msprop:Generator_ColumnPropNameInRow="RatingSum" msprop:Generator_ColumnPropNameInTable="RatingSumColumn" msprop:Generator_UserColumnName="RatingSum" type="xs:int" />
              <xs:element name="TotalRatingVotes" msprop:Generator_ColumnVarNameInTable="columnTotalRatingVotes" msprop:Generator_ColumnPropNameInRow="TotalRatingVotes" msprop:Generator_ColumnPropNameInTable="TotalRatingVotesColumn" msprop:Generator_UserColumnName="TotalRatingVotes" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Nop_Report_CustomerAddress" msprop:Generator_TableClassName="Nop_Report_CustomerAddressDataTable" msprop:Generator_TableVarName="tableNop_Report_CustomerAddress" msprop:Generator_RowChangedName="Nop_Report_CustomerAddressRowChanged" msprop:Generator_TablePropName="Nop_Report_CustomerAddress" msprop:Generator_RowDeletingName="Nop_Report_CustomerAddressRowDeleting" msprop:Generator_RowChangingName="Nop_Report_CustomerAddressRowChanging" msprop:Generator_RowEvHandlerName="Nop_Report_CustomerAddressRowChangeEventHandler" msprop:Generator_RowDeletedName="Nop_Report_CustomerAddressRowDeleted" msprop:Generator_RowClassName="Nop_Report_CustomerAddressRow" msprop:Generator_UserTableName="Nop_Report_CustomerAddress" msprop:Generator_RowEvArgName="Nop_Report_CustomerAddressRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CustomerID" msprop:Generator_ColumnVarNameInTable="columnCustomerID" msprop:Generator_ColumnPropNameInRow="CustomerID" msprop:Generator_ColumnPropNameInTable="CustomerIDColumn" msprop:Generator_UserColumnName="CustomerID" type="xs:int" />
              <xs:element name="CustomerGUID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnCustomerGUID" msprop:Generator_ColumnPropNameInRow="CustomerGUID" msprop:Generator_ColumnPropNameInTable="CustomerGUIDColumn" msprop:Generator_UserColumnName="CustomerGUID" type="xs:string" />
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn" msprop:Generator_UserColumnName="Username">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PasswordHash" msprop:Generator_ColumnVarNameInTable="columnPasswordHash" msprop:Generator_ColumnPropNameInRow="PasswordHash" msprop:Generator_ColumnPropNameInTable="PasswordHashColumn" msprop:Generator_UserColumnName="PasswordHash">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SaltKey" msprop:Generator_ColumnVarNameInTable="columnSaltKey" msprop:Generator_ColumnPropNameInRow="SaltKey" msprop:Generator_ColumnPropNameInTable="SaltKeyColumn" msprop:Generator_UserColumnName="SaltKey">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AffiliateID" msprop:Generator_ColumnVarNameInTable="columnAffiliateID" msprop:Generator_ColumnPropNameInRow="AffiliateID" msprop:Generator_ColumnPropNameInTable="AffiliateIDColumn" msprop:Generator_UserColumnName="AffiliateID" type="xs:int" />
              <xs:element name="BillingAddressID" msprop:Generator_ColumnVarNameInTable="columnBillingAddressID" msprop:Generator_ColumnPropNameInRow="BillingAddressID" msprop:Generator_ColumnPropNameInTable="BillingAddressIDColumn" msprop:Generator_UserColumnName="BillingAddressID" type="xs:int" />
              <xs:element name="ShippingAddressID" msprop:Generator_ColumnVarNameInTable="columnShippingAddressID" msprop:Generator_ColumnPropNameInRow="ShippingAddressID" msprop:Generator_ColumnPropNameInTable="ShippingAddressIDColumn" msprop:Generator_UserColumnName="ShippingAddressID" type="xs:int" />
              <xs:element name="LastPaymentMethodID" msprop:Generator_ColumnVarNameInTable="columnLastPaymentMethodID" msprop:Generator_ColumnPropNameInRow="LastPaymentMethodID" msprop:Generator_ColumnPropNameInTable="LastPaymentMethodIDColumn" msprop:Generator_UserColumnName="LastPaymentMethodID" type="xs:int" />
              <xs:element name="LastAppliedCouponCode" msprop:Generator_ColumnVarNameInTable="columnLastAppliedCouponCode" msprop:Generator_ColumnPropNameInRow="LastAppliedCouponCode" msprop:Generator_ColumnPropNameInTable="LastAppliedCouponCodeColumn" msprop:Generator_UserColumnName="LastAppliedCouponCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GiftCardCouponCodes" msprop:Generator_ColumnVarNameInTable="columnGiftCardCouponCodes" msprop:Generator_ColumnPropNameInRow="GiftCardCouponCodes" msprop:Generator_ColumnPropNameInTable="GiftCardCouponCodesColumn" msprop:Generator_UserColumnName="GiftCardCouponCodes">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CheckoutAttributes" msprop:Generator_ColumnVarNameInTable="columnCheckoutAttributes" msprop:Generator_ColumnPropNameInRow="CheckoutAttributes" msprop:Generator_ColumnPropNameInTable="CheckoutAttributesColumn" msprop:Generator_UserColumnName="CheckoutAttributes">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LanguageID" msprop:Generator_ColumnVarNameInTable="columnLanguageID" msprop:Generator_ColumnPropNameInRow="LanguageID" msprop:Generator_ColumnPropNameInTable="LanguageIDColumn" msprop:Generator_UserColumnName="LanguageID" type="xs:int" />
              <xs:element name="CurrencyID" msprop:Generator_ColumnVarNameInTable="columnCurrencyID" msprop:Generator_ColumnPropNameInRow="CurrencyID" msprop:Generator_ColumnPropNameInTable="CurrencyIDColumn" msprop:Generator_UserColumnName="CurrencyID" type="xs:int" />
              <xs:element name="TaxDisplayTypeID" msprop:Generator_ColumnVarNameInTable="columnTaxDisplayTypeID" msprop:Generator_ColumnPropNameInRow="TaxDisplayTypeID" msprop:Generator_ColumnPropNameInTable="TaxDisplayTypeIDColumn" msprop:Generator_UserColumnName="TaxDisplayTypeID" type="xs:int" />
              <xs:element name="IsTaxExempt" msprop:Generator_ColumnVarNameInTable="columnIsTaxExempt" msprop:Generator_ColumnPropNameInRow="IsTaxExempt" msprop:Generator_ColumnPropNameInTable="IsTaxExemptColumn" msprop:Generator_UserColumnName="IsTaxExempt" type="xs:boolean" />
              <xs:element name="IsAdmin" msprop:Generator_ColumnVarNameInTable="columnIsAdmin" msprop:Generator_ColumnPropNameInRow="IsAdmin" msprop:Generator_ColumnPropNameInTable="IsAdminColumn" msprop:Generator_UserColumnName="IsAdmin" type="xs:boolean" />
              <xs:element name="IsGuest" msprop:Generator_ColumnVarNameInTable="columnIsGuest" msprop:Generator_ColumnPropNameInRow="IsGuest" msprop:Generator_ColumnPropNameInTable="IsGuestColumn" msprop:Generator_UserColumnName="IsGuest" type="xs:boolean" />
              <xs:element name="IsForumModerator" msprop:Generator_ColumnVarNameInTable="columnIsForumModerator" msprop:Generator_ColumnPropNameInRow="IsForumModerator" msprop:Generator_ColumnPropNameInTable="IsForumModeratorColumn" msprop:Generator_UserColumnName="IsForumModerator" type="xs:boolean" />
              <xs:element name="TotalForumPosts" msprop:Generator_ColumnVarNameInTable="columnTotalForumPosts" msprop:Generator_ColumnPropNameInRow="TotalForumPosts" msprop:Generator_ColumnPropNameInTable="TotalForumPostsColumn" msprop:Generator_UserColumnName="TotalForumPosts" type="xs:int" />
              <xs:element name="Signature" msprop:Generator_ColumnVarNameInTable="columnSignature" msprop:Generator_ColumnPropNameInRow="Signature" msprop:Generator_ColumnPropNameInTable="SignatureColumn" msprop:Generator_UserColumnName="Signature">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="300" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AdminComment" msprop:Generator_ColumnVarNameInTable="columnAdminComment" msprop:Generator_ColumnPropNameInRow="AdminComment" msprop:Generator_ColumnPropNameInTable="AdminCommentColumn" msprop:Generator_UserColumnName="AdminComment">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="4000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Active" msprop:Generator_ColumnVarNameInTable="columnActive" msprop:Generator_ColumnPropNameInRow="Active" msprop:Generator_ColumnPropNameInTable="ActiveColumn" msprop:Generator_UserColumnName="Active" type="xs:boolean" />
              <xs:element name="Deleted" msprop:Generator_ColumnVarNameInTable="columnDeleted" msprop:Generator_ColumnPropNameInRow="Deleted" msprop:Generator_ColumnPropNameInTable="DeletedColumn" msprop:Generator_UserColumnName="Deleted" type="xs:boolean" />
              <xs:element name="RegistrationDate" msprop:Generator_ColumnVarNameInTable="columnRegistrationDate" msprop:Generator_ColumnPropNameInRow="RegistrationDate" msprop:Generator_ColumnPropNameInTable="RegistrationDateColumn" msprop:Generator_UserColumnName="RegistrationDate" type="xs:dateTime" />
              <xs:element name="TimeZoneID" msprop:Generator_ColumnVarNameInTable="columnTimeZoneID" msprop:Generator_ColumnPropNameInRow="TimeZoneID" msprop:Generator_ColumnPropNameInTable="TimeZoneIDColumn" msprop:Generator_UserColumnName="TimeZoneID">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AvatarID" msprop:Generator_ColumnVarNameInTable="columnAvatarID" msprop:Generator_ColumnPropNameInRow="AvatarID" msprop:Generator_ColumnPropNameInTable="AvatarIDColumn" msprop:Generator_UserColumnName="AvatarID" type="xs:int" />
              <xs:element name="DateOfBirth" msprop:Generator_ColumnVarNameInTable="columnDateOfBirth" msprop:Generator_ColumnPropNameInRow="DateOfBirth" msprop:Generator_ColumnPropNameInTable="DateOfBirthColumn" msprop:Generator_UserColumnName="DateOfBirth" type="xs:dateTime" minOccurs="0" />
              <xs:element name="AddressId" msprop:Generator_ColumnVarNameInTable="columnAddressId" msprop:Generator_ColumnPropNameInRow="AddressId" msprop:Generator_ColumnPropNameInTable="AddressIdColumn" msprop:Generator_UserColumnName="AddressId" type="xs:int" />
              <xs:element name="Expr1" msprop:Generator_ColumnVarNameInTable="columnExpr1" msprop:Generator_ColumnPropNameInRow="Expr1" msprop:Generator_ColumnPropNameInTable="Expr1Column" msprop:Generator_UserColumnName="Expr1" type="xs:int" />
              <xs:element name="IsBillingAddress" msprop:Generator_ColumnVarNameInTable="columnIsBillingAddress" msprop:Generator_ColumnPropNameInRow="IsBillingAddress" msprop:Generator_ColumnPropNameInTable="IsBillingAddressColumn" msprop:Generator_UserColumnName="IsBillingAddress" type="xs:boolean" />
              <xs:element name="FirstName" msprop:Generator_ColumnVarNameInTable="columnFirstName" msprop:Generator_ColumnPropNameInRow="FirstName" msprop:Generator_ColumnPropNameInTable="FirstNameColumn" msprop:Generator_UserColumnName="FirstName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LastName" msprop:Generator_ColumnVarNameInTable="columnLastName" msprop:Generator_ColumnPropNameInRow="LastName" msprop:Generator_ColumnPropNameInTable="LastNameColumn" msprop:Generator_UserColumnName="LastName">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PhoneNumber" msprop:Generator_ColumnVarNameInTable="columnPhoneNumber" msprop:Generator_ColumnPropNameInRow="PhoneNumber" msprop:Generator_ColumnPropNameInTable="PhoneNumberColumn" msprop:Generator_UserColumnName="PhoneNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Expr2" msprop:Generator_ColumnVarNameInTable="columnExpr2" msprop:Generator_ColumnPropNameInRow="Expr2" msprop:Generator_ColumnPropNameInTable="Expr2Column" msprop:Generator_UserColumnName="Expr2">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FaxNumber" msprop:Generator_ColumnVarNameInTable="columnFaxNumber" msprop:Generator_ColumnPropNameInRow="FaxNumber" msprop:Generator_ColumnPropNameInTable="FaxNumberColumn" msprop:Generator_UserColumnName="FaxNumber">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Company" msprop:Generator_ColumnVarNameInTable="columnCompany" msprop:Generator_ColumnPropNameInRow="Company" msprop:Generator_ColumnPropNameInTable="CompanyColumn" msprop:Generator_UserColumnName="Company">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address1" msprop:Generator_ColumnVarNameInTable="columnAddress1" msprop:Generator_ColumnPropNameInRow="Address1" msprop:Generator_ColumnPropNameInTable="Address1Column" msprop:Generator_UserColumnName="Address1">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Address2" msprop:Generator_ColumnVarNameInTable="columnAddress2" msprop:Generator_ColumnPropNameInRow="Address2" msprop:Generator_ColumnPropNameInTable="Address2Column" msprop:Generator_UserColumnName="Address2">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="City" msprop:Generator_ColumnVarNameInTable="columnCity" msprop:Generator_ColumnPropNameInRow="City" msprop:Generator_ColumnPropNameInTable="CityColumn" msprop:Generator_UserColumnName="City">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StateProvinceID" msprop:Generator_ColumnVarNameInTable="columnStateProvinceID" msprop:Generator_ColumnPropNameInRow="StateProvinceID" msprop:Generator_ColumnPropNameInTable="StateProvinceIDColumn" msprop:Generator_UserColumnName="StateProvinceID" type="xs:int" />
              <xs:element name="ZipPostalCode" msprop:Generator_ColumnVarNameInTable="columnZipPostalCode" msprop:Generator_ColumnPropNameInRow="ZipPostalCode" msprop:Generator_ColumnPropNameInTable="ZipPostalCodeColumn" msprop:Generator_UserColumnName="ZipPostalCode">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CountryID" msprop:Generator_ColumnVarNameInTable="columnCountryID" msprop:Generator_ColumnPropNameInRow="CountryID" msprop:Generator_ColumnPropNameInTable="CountryIDColumn" msprop:Generator_UserColumnName="CountryID" type="xs:int" />
              <xs:element name="CreatedOn" msprop:Generator_ColumnVarNameInTable="columnCreatedOn" msprop:Generator_ColumnPropNameInRow="CreatedOn" msprop:Generator_ColumnPropNameInTable="CreatedOnColumn" msprop:Generator_UserColumnName="CreatedOn" type="xs:dateTime" />
              <xs:element name="UpdatedOn" msprop:Generator_ColumnVarNameInTable="columnUpdatedOn" msprop:Generator_ColumnPropNameInRow="UpdatedOn" msprop:Generator_ColumnPropNameInTable="UpdatedOnColumn" msprop:Generator_UserColumnName="UpdatedOn" type="xs:dateTime" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Nop_Report_CustomerAddress" />
      <xs:field xpath="mstns:CustomerID" />
      <xs:field xpath="mstns:AddressId" />
    </xs:unique>
  </xs:element>
</xs:schema>